Creating a report based on multiple queries in Access

  • Thread starter Thread starter Prakash
  • Start date Start date
P

Prakash

Hi,here's my problem.I have a multiple queries and I want
to add them to my report using the wizard but instead I
get a warning message saying that I have chosen fields
from a record source that the wizard can't connect to.But
when I choose a single query, it works fine.Howdo I solve
this problem please help.
 
You can most certainly add the data from several queries
to a report, however, be careful since when combining
several querries into one you may have problems with
record replication due to the one to many relationships.
Maybe you can report the querries in sub reports instead.
This would prevent the replication problems. Filtering in
this case could be controlled by stting proper master-
child relationships.
If you have more questions I would need some more
specifics.
Hope this helps.
Fons
 
Back
Top