create a report from multiple table

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

Guest

Hi,

I have create a database for equipment list with a unique equipment number.
some main equipment also has subequipments store in a different tables.

can anyone help me to create a report to include all the equipment and their
subequipment?

thanks
 
First create an Access query joining the two tables. In the query, include
all the fields (columns) from each table that you'll want on the report.
Within this query you can also create one or more "calculated fields" ---
fields that are made up of information taken from one or more of the actual
data fields from the tables.

Then build the report using the query as the RecordSource. Your report will
have access to all of the data in the joined tables. You'll probably want
to set up control breaks in the report on the main equipment number.

The definition of the report sequence and whatever control breaks you want
are defined in the report. That's also where you define the report
header/footer (if any) and page header/footer (if any).

Bob.
 
Back
Top