Report Grouping Question

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
 
M

Marshall Barton

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.


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top