Fields from record sources wizard can't connect



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question