I need to create an automated query to run everyday based on a Date/Time field. I already know what the Date/Time field should be, for example 07/02/01 12:00 AM, but the day will change every day. How do I create the value for the date/time field automatically?
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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date/Time field queries 1
- Thread starter lk5990
- Start date
-
1
- #2
LonnieJohnson
Programmer
In the query grid you would put...
Like Date() And Like #12:00:00 AM#
This will use the Date() function to pull every record from today's date and the constant 12:00:00 am. ljprodev@yahoo.com
ProDev
MS Access Applications
Like Date() And Like #12:00:00 AM#
This will use the Date() function to pull every record from today's date and the constant 12:00:00 am. ljprodev@yahoo.com
ProDev
MS Access Applications
- Status
Similar threads
- Locked
- Question
- Locked
- Question
