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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date query

Status
Not open for further replies.

noonan1

Technical User
Joined
Feb 20, 2003
Messages
10
Location
IE
I have a project deliverables table with a field called due date, i need to query this table so that values appear were the due date equals todays date. I am unsure how to do this and would appreciate any help you could give me, thank you in advance.
 
Open your query and in the "Criteria" field for the duedate field enter: =Date()

Then when the query runs it return only the date with a due date of today.

DH
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top