Two date specific Queries in one report

deeda67

Registered User.
Local time
Today, 01:13
Joined
Jan 24, 2007
Messages
30
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?
 
Hi,

You could have an union query feeding into the report or have sub reports in the main report if they can be linked .
 
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!!!!!!!!!!!!
 

Users who are viewing this thread

Back
Top Bottom