Dates

  • Thread starter Thread starter Willy2
  • Start date Start date
W

Willy2

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date quieries 1
Complex Record Selection 1
Most recent date 1
Date issue 9
Auto select Billing Cost 8
Help with DMin? 2
Record Plus record in access query 8
top 5 days for each user 12

Back
Top