Fields from record sources wizard can't connect

  • Thread starter Thread starter Jill
  • Start date Start date
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?
 
Use only one query. Post the SQL of both and someone can show you how to
combine and compare.
 
Back
Top