How do I make a master [Start Date] and [End Date]?
Posted on 2011-03-09
Please forgive me if this answer is easily answered and found elsewhere on this site but I have not been able to figure this out.
I am also VERY new to this so please don't assume I know too much when answering.
I have a query that is composed of several other crosstab queries. The master query will be used to make a report. Each crosstab query is limited by the same date range. The date range will never differ between the crosstabs.
I want the end result report to have a user entered date range from a form and I only want to enter it once. As it stands now, if I want the range to change, I must go into each query and manually change the date. I tried using the "Between [Start Date[ and [End Date]" criteria but right now, it must be entered for every query and gets very cumbersome (And to be honest, I havent actually got that to work correctly) Also, I am unable to control the date range from just one query and join it to the rest, I tried it and the integrity of the information was lost. So if thats the only way to do it, then I'd have to figure out how to rebuild the whole thing.
So, is there a way to have a form with a user generated date range that will be applied to all the queries used to generate the report?