Report Grouping Question

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

Guest

Hi. I am having some trouble building a report.

Each column's info comes from a diff table. The first column comes from the
'main table' and the second and third each have a many-to-one relationship
with the first column. The report I want to create would look like this:

last name, first name

doctor name address phone

child name bday

*There can be multiple doctors and multiple children.

I've been working on it for a while but i am not getting it right. Any help
would be appreciated.

-Ryan
 
Ryan said:
Hi. I am having some trouble building a report.

Each column's info comes from a diff table. The first column comes from the
'main table' and the second and third each have a many-to-one relationship
with the first column. The report I want to create would look like this:

last name, first name

doctor name address phone

child name bday

*There can be multiple doctors and multiple children.

I've been working on it for a while but i am not getting it right. Any help
would be appreciated.
Click to expand...


First, create a query that joins the tables on their linking
fields.

Once the query is retrieving the desired dataset, create a
report based on the query.

Use the report's Sorting and Grouping window (View menu) to
create two groups with headers. first for the person
identifier field and then the doctor's id field.

Put the corresponding data in the header sections and place
the child data in the detail section.
 
Back
Top