Creating Reports from Tables and Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you create a report using fields from a Table and Query at the same time. I can get each to work individually, but I cannot figure out how to get the Report Wizard to allow me to select fields from both a Query and Table. Please advise

Thanks
 
You can have only 1 record source specified in your
report. Is there any way you can combine the table and
query together in another query and use that for the
report's record source?

Otherwise, perhaps you can use a main report and
subreport. One having the table and the other having the
query as their record source.

Hope this helps.
-----Original Message-----
How do you create a report using fields from a Table and
Click to expand...
Query at the same time. I can get each to work
individually, but I cannot figure out how to get the
Report Wizard to allow me to select fields from both a
Query and Table. Please advise.
 
Back
Top