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!

Register Log in
  • Congratulations Chriss Miller 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

Status
Not open for further replies.
lk5990

lk5990

Programmer
Jul 2, 2001
7
US
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?
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
429
cimoli
cimoli
v5652
  • Locked
  • Question
Ribbon icons missing each time when MS Windows 10 update
Replies
0
Views
347
v5652
v5652
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
331
Andrzejek
Andrzejek
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
392
dhookom
dhookom
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
311
clevercat88
clevercat88

Part and Inventory Search

Sponsor

Back
Top