I have created a query that has several fields of data, one of fields is "CourseStateDate", the records under that field are "short date" format. I would like the query to produce only those records with "CourseStartDates" from Monday of the current week and looking four weeks into the future. Can someone please help...it's driving me crazy.
Looking into the future...
- Thread starter ozzy68
- Start date
Alansidman
AWF VIP
- Local time
- Today, 16:23
- Joined
- Jul 31, 2008
- Messages
- 1,493
If I were doing this, based upon the information supplied I would create a search form with two unbound fields and a command button.
In the first field I would place the start date and in the second field I would place either a formula using DateAdd function or the actual date for the end date.
I would build code behind the command button to run the query.
In the query, in the criteria section for the date field, I would use the following criteria
I would add two other buttons to the form
One to clear the filter and one to close the form.
Good Luck.
Alan
In the first field I would place the start date and in the second field I would place either a formula using DateAdd function or the actual date for the end date.
I would build code behind the command button to run the query.
In the query, in the criteria section for the date field, I would use the following criteria
Code:
Between Forms!YourSearchFormName.FirstfieldName and Forms!YourSearchformName.SecondFieldNameI would add two other buttons to the form
One to clear the filter and one to close the form.
Good Luck.
Alan
Similar threads
