Report from two linked tables

R

Robert Robinson

I have created two normalized tables, and would like to create a report
combining information from both.

Is the best practice to create a query which pulls the required information
from both tables, then create the report based on this query? I believe that
I have seen that it is, but wanted to confirm before going down the wrong
road.
 
O

Ofer

It would be better to do it that way, create a query based on the two tables,
until you get the required data, When that is done, save the query and use
the Report wizard to create a new report that is based on this query.

That way you can use this quey for different uses.
 
Top