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

KARL DEWEY

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

Query to display the difference of period for an employee. 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
DATES - Grouping sets of sequential dates 3
Find then highlight in yellow 6
Dates - Grouping Start and End dates of sequential assignments. 0
DATE STATISTICAL 1
Looking up across date ranges in Access 2
Sequential values in access table 0

Top