calculate averages in an access report

[Guest]

I am trying to calculate an averages based on 5 or 6 query results and I keep
getting an error message. The queries work fine but when I try to use them
in a report I get a message saying "You have chosen fields from record
sources which the wizard can't connect."

 

[PC Datasheet]

Hi Joan,

If you look at the relationships window, you will see the relationships are
all between tables; no queries. The Form wizard and Report wizard use the
relationships to build the recordsources when there are multiple tables and
queries in the recordsource. Additionally, the wizards attempt to join the
multiple tables and queries. When the wizard can not join ALL the tables and
queries, you get the message "You have chosen fields from record sources
which the wizard can't connect." You haven't done anything wrong! Rather
than trying to use the wizard, build your recordsource manually by choosing
Design rather than the wizard.