Access Queries

C

Cindy Marie

I need to perform a query that will show me all of the items that were posted
between two separate dates,such as 05/26/2009 - 10/24/2009. Can anyone please
offer a bit of help.
Thanks a lot.
 
M

Marshall Barton

Cindy Marie said:
I need to perform a query that will show me all of the items that were posted
between two separate dates,such as 05/26/2009 - 10/24/2009. Can anyone please
offer a bit of help.
Click to expand...


Set the dateposted field's criteria to:

Between #05/26/2009# And #10/24/2009#
or
= #05/26/2009# And < #10/25/2009#
Click to expand...

depending on if the date field contains a time.
 
Top