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.
 

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

Similar Threads

Need some PWA help 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
creating query- 'record sources which the wizard can't connect' 2
Avoid duplicated item when combining two queries 3
Pulling last week's data 4
Access 2000 report problem 1
Not sure how to make this work 3
Count Distinct Values 2

Top