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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an update query that uses multiple parameters 2
Querying Date Field, Disregarding Year 2
query on date 1
Combine Duplicates in Query 0
Date calculation on 2 fields 5
Date Query using date in the date field 3
DSum update query with multiple fields 0
HOW TO OBTAIN ONLY THE DATE OF A timestamp FIELD 3

Back
Top