Dates

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
 
J

Jeff Boyce

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

Creating a Search using a combo box and then creating a report. 4
Dates In Excel 5
Clicking link tasks again increases duration 0
How to automate update on weekly reports spreadsheet 0
Append Crosstab Query to Existing Table 0
date quieries 2
Sorting and filtering text 0
Default Dates 2

Top