W Willy2 Sep 8, 2009 #1 I need to put in a query dates beginning 9/1/2007 thru 8/31/2008. How do I enter that into the query under date? Thanks
I need to put in a query dates beginning 9/1/2007 thru 8/31/2008. How do I enter that into the query under date? Thanks
J Jeff Boyce Sep 8, 2009 #2 In design view of your query, under the field that hold the date values, in the row related to selection criteria, use something like: Between #9/1/2007# And #8/31/2008# Regards Jeff Boyce Microsoft Office/Access MVP
In design view of your query, under the field that hold the date values, in the row related to selection criteria, use something like: Between #9/1/2007# And #8/31/2008# Regards Jeff Boyce Microsoft Office/Access MVP