report question

[Jessica]

Hello All,


Should I create reports from a query or more than one table or does it
not matter.


TIA,
Jess

 

[Al Camp]

Jessica,
Your table design, and what you need to see on your report, are what
determine the RecordSource of a report.
If one table , or a query based on one table is sufficient to provide the
report with the data it needs... then so be it. If more "related"
information
form other tables is needed, then add those tables to suit.

 

[Guest]

your best bet is like al wrote, go to the record source of the report (report
properties | data | Record source) and click on the right, on the icon with
three dots, then the query builder will open. you can then run your data and
you can add there what you need.

sam