Multiple Start and End Times

  • Thread starter Thread starter jserrone via AccessMonster.com
  • Start date Start date
J

jserrone via AccessMonster.com

Hello Everyone,

I would like to run one query that can accommodate entering twelve possible
date ranges and output the data all in one query. I could accomplish that by
writing 12 queries and attaching each one to a start and end box on a form
and then doing a Union Query to obtain one result. I think this might be the
long way to accomplish this.

Is there a better way to get the result on one query for multiple Start and
end Date Ranges?

Thanks
 
Yes, build a table with two fields Start_Date and End_Date ( three if you a
going to use the same mix of dates and include a Yes/No field).
In a query put your data table and dates table without joining.

Use this as criteria on your data table date field ---
Between [Start_Date] And [End_Date]

To use the Yes/No field add it to the field row of the query design view and
use -1 (minus one) as criteria for Yes.
 
Back
Top