Report from Query

[Guest]

I had posted this in the query forum, but I think it is really a report
problem, so I am posting it here. Sorry for the double-post.

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 one 2-page 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.

I have tried putting the address info in the Group header, but it is still
having this problem.

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

Thanks!

 

[Duane Hookom]

Do you have a Property Information table and a Past Owner table? It sounds
like you have the Past Owner records in the record source of the main report
as well as using a subreport with the same Past Owner table. If so, remove
the Past Owner records from the record source of the main report.

 

[Guest]

Yes! That was it! I had both tables in my query. I knew it would be
something so simple!

Only problem I have now is that the address (the group header) comes up on a
page all by itself, but I'm sure that will be an easy fix as soon as I get a
chance to look.

 

[Guest]

Yep, it was just a quick fix - it's all fixed now!

Thanks a lot!