supress duplicate data

[Guest]

I'm creating a report that pulls inventory data from a query. There are 3
tables which I pull from. Some inventory items have quote information pulled
in from table 3. Becasue of the linking, inventory items are duplicated in
the query. So when I run the report the inventory items are also duplicated.
I only want the inventory item listed once but quote information listed as my
times as needed.
e.g.

item qty bo order price Quote
Vendor
12345 5 0 10 $1.00 .99
Ohio

..95 Texas

..98 Florida

I'm not sure if the query needs changed or if I can make the corrections in
the report.

 

[Albert D.Kallal]

remove the stuff from the 3rd table in the query.

Build a small report that lists the repeating data..and then place this new
report as a sub-report for the repeating data.

Remember, a form you use a sub-form to enter the "detail" data. So, to
report this kind of data, you use a sub-report....