I have a query that is run with the parameter Like"*"&[Notification Date]&"*" which brings up all the records for a particular date. Is there any way to write the parameter so you can bring up several different dates at a time or a range like May-Aug 2000? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query with Date Parameter 1
- Thread starter DaveHam
- Start date
-
1
- #2
jimmythegeek
Programmer
Between [Enter Start Date] And [Enter Ending Date]<br><br>If you enter 5/1/00 as your Start Date and 8/31/00 as your Ending Date, you will get May-Aug 2000. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href= Application Development
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question