Dates

G

George Schneider

I trying to writie a query that pulls all records where the date in a field is prior to today. how can this be accomplished.
 
J

Jeff Boyce

George

In your query, use "<Date()" as a criterion in the datefield (leave out the
quotes).

Good luck

Jeff Boyce
<Access MVP>
 

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

Display weeks from a Milestone 0
Fields 2
Replacing a phrase with carriage returns 1
Formatting templates 7
Filtering records by date 2
Use TODAY() function as the criteria in a SUMIF formula 1
How to automate update on weekly reports spreadsheet 0
Date Format 3

Top