Fields from record sources wizard can't connect

J

Jill

I have two separate queries - one for current year and one for prior year.
Each includes day of week and the invoice total for that day. I need to
create a report that shows for every day of the week the invoices generated
comparing current year to prior.

When I try to combine the queries - I can't because I have chosen record
fields that access cannot connect. Any suggestions?
 
K

KARL DEWEY

Use only one query. Post the SQL of both and someone can show you how to
combine and compare.
 
Top