Multiple Start and Ending Dates

[jserrone]

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

Joe

 

[KenHigg]

My first question would be will you always want to put 12 or would you need a different number each time?