Two date specific Queries in one report

[deeda67]

I have two date parameter queries set up (user sets dates are through a form). What I need is to have both of these queries in a format I can put them in one report and total the amount of sales at the bottom. Basically, it is a running sales report for the year. What I don't know is how to get both of these queries in one report. Any suggestions?

 

[P_Henry]

Hi,

You could have an union query feeding into the report or have sub reports in the main report if they can be linked .

 

[deeda67]

You Are A Genius!

THANK YOU! I used the union query to put both queries together and it worked!!!!! I just have to add a field to one because the other had more fields, but other than that, it worked!!!!!!!!!!!!!!

THANK YOU THANK YOU!!!!!!!!!!!!