Problems with queries/reports with multiple tables

C

cprav

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!
 
M

Marshall Barton

cprav said:
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.
Click to expand...


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.
 
C

cprav

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!
 
C

cprav

Problem has been solved, thank you!! :)



cprav said:
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!
Click to expand...
 
Top