Problems with queries/reports with multiple tables

[Guest]

I have a database that has a table/form with property information with a
linked subform with all the past owners of that property.

I want to create a report that will print the information on the property
with the list of past owners.

I tried to create a query to combine the to tables, but it gives me an entry
for each owner. (If the property had 6 past owners, I get 6 results). I
have it set to a paramenter query so that the user just has to type in the
address and it will autmatically print the report. Because it is doing this,
it will basically print 6 copies of the same thing.

If the solution requires programming, please give me step by step
instructions, as I am new to that area.

Quick replies would be useful as this is a work-related project.

Thanks!

 

[Marshall Barton]

I have a database that has a table/form with property information with a
linked subform with all the past owners of that property.

I want to create a report that will print the information on the property
with the list of past owners.

I tried to create a query to combine the to tables, but it gives me an entry
for each owner. (If the property had 6 past owners, I get 6 results). I
have it set to a paramenter query so that the user just has to type in the
address and it will autmatically print the report. Because it is doing this,
it will basically print 6 copies of the same thing.

If the solution requires programming, please give me step by step
instructions, as I am new to that area.

Use Sorting and Grouping (View menu) in the report to create
a group with header on the property id field. Then you can
place the address info in the group header section.

 

[Guest]

Thanks Marshall,

That is what I thought I should do, and did. I did try again though, this
morning but it is still doing it. I know it can be done, but just can't
figure out what I'm doing wrong!

 

[Guest]

Problem has been solved, thank you!!

Thanks Marshall,

That is what I thought I should do, and did. I did try again though, this
morning but it is still doing it. I know it can be done, but just can't
figure out what I'm doing wrong!