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>
 
Top