G Guest Oct 24, 2003 #1 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.
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 Oct 24, 2003 #2 George In your query, use "<Date()" as a criterion in the datefield (leave out the quotes). Good luck Jeff Boyce <Access MVP>
George In your query, use "<Date()" as a criterion in the datefield (leave out the quotes). Good luck Jeff Boyce <Access MVP>
