Report.

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a database that consists of two tables. I have
linked the tables, queried the two tables and I have the
information I want. I want to report on the query.
Here's where I have the problem. The information in table
one is biographical and needs to show on the report only
once, such as at the top. The information in table two is
multiple records that are unique. The problem is, all the
biographical repeats with each record, I just need to be
able to see it once. Or, is it possible to create a
single report based on two separate queries of two
separate tables?
 
Use the sorting and grouping dialog to create a grouping on the "linking"
field between the two tables. Display the section header and place
"repeating" information/fields in this header section.
 
Back
Top