Access Queries

[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.

 

[Marshall Barton]

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.

Set the dateposted field's criteria to:

Between #05/26/2009# And #10/24/2009#
or

= #05/26/2009# And < #10/25/2009#

depending on if the date field contains a time.