I did something simalar to this, I had like 12 queries which I wanted to compile the data for into a report. Each of these queries has date parameters like this: Between [Type Desired Date @ 8:00 am] And [Type Desired Date @ 5:00 PM]. Now what I did to get this all into one report with it only prompting for the 2 dates/times I wanted was made sure each of the queries date fields had this "Between [Type Desired Date @ 8:00 am] And [Type Desired Date @ 5:00 PM]" in the date/time field. I then created a new query with all of the other queries in it and based my report off of that. Since the parameters are the same for each of the queries when I run the report it only prompts me the 2 times instead of 24 for each of the queries.