Prev: Custom Function
Next: Removing Certain Records from a Query and Report
From: Cindy Marie Cindy on 25 Apr 2010 15:38
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.
From: Marshall Barton on 25 Apr 2010 16:12
Cindy Marie <Cindy Marie(a)discussions.microsoft.com> wrote:

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

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Custom Function
Next: Removing Certain Records from a Query and Report