gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
I have a date field (PDIR Completed). I would like to have a form that shows a query. But I want that query to based off a selection from a pulldown on my form (example of list: Last 7 Days, Last 14 Days, Last 30 Day and Last 60 Days)
If I select "Last 7 Days" I want the query (and therefore the Form) to only show the records where the PDIR Completed date was in the last seven days from today.
Any suggestions?
If I select "Last 7 Days" I want the query (and therefore the Form) to only show the records where the PDIR Completed date was in the last seven days from today.
Any suggestions?