Multiple Criteria's

  • Thread starter Rick_DeSimone via AccessMonster.com
  • Start date
R

Rick_DeSimone via AccessMonster.com

I want to create a Query that pulls records from my table with more than one
date range. Example, Customers we did busines with between 4-01-05 thru 04-30-
05 and 04-01-06 thru 04-30-06. Currently I have a seperate query for each
year.
 
G

Guest

There are several ways but the simple one is like this --
Between 4/1/2005 AND 4/30/2005 OR Between 4/1/2006 AND 4/30/2006
 

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

Receiving valid Multicast address failed on mini port driver 0
Query to display the difference of period for an employee. 1
DATES - Grouping sets of sequential dates 3
DATE STATISTICAL 1
Average interpurchase times 4
Looking up across date ranges in Access 2
select entries keyed in after 5:30 PM 1
This should be simple but I don't know how! 6

Top