Have a Problem With Fields Type Date in Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Guys Need help with a query that i want to do, Im trying to make a query that
the field date takes automatic only the records that are from the day that we
are working on...For Example. In my table im putting all the instalation date
of my clients and at the end of the day i only want to know which clients i
have instaled in that day...the next day the same query must have diferent
clients since i have entered a different date of termination for it.

Please help me with this! Thanks in advance for all the help you can give me.
 
In the Criteria row of your query, under the date field, enter:
Date()

This function returns the system date.
Each day you run the query, it will match the records for today.
 
Back
Top