Tables and Queries

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

Guest

How do you generate a report using fields from a table and a query. I have tried the wizard as well as the Expression Builder and have not had any success. I can get data from the query or the table, but not both. Please advise.
 
How do you generate a report using fields from a table and a query. I have tried the wizard as well as the Expression Builder and have not had any success. I can get data from the query or the table, but not both. Please advise.
Click to expand...

A report can only have one record source at a time.
If you need data from a query and from a table, make a new query that
combines both. Make sure all the relationships are properly
established.
If there is just one record's data needed from the table, you could
simply use a DLookUp() to find a field in that one record, in which
case it need not be included in the record source.
 
Back
Top