Subreport with repeat info

[tdm32]

I have a subreport form a query in a report. The problem I am having is that rather than only displaying the information from the query once, as I would like it to, it is displaying the same information multiple times.
This query consists of hardware information for example computers, cameras, hubs power supplys ect.. For instance if the query pulls the information for 2 cameras and 2 computers, the subreport will be shown 4 times, with the camera and computer information show seperate as oppose to all of them being shown once within this one subreport.

Any assistance or guidance will be greatly appreciated.

 

[WayneRyan]

tdm,

Get your query in design view, click on the exclamation point,
after the query runs, note how many records. Return to design
view by right-clicking and selecting design view.

Then right-click on the line "joining" your two tables.

Choose "select all" from the left table, and "where equal" on
the right hand table.

Rerun the query by clicking on the exclamation point again.
If the number is not right, return to design view and tinker
with the join properties.

Wayne

 

[tdm32]

Thanks for the reply Wayne, but let try to further clarify my situation.

The two subreports I am running are coming from two seperate queries. the two seperate tables are joined by a third table called Project.

But basically I'm trying to get one subreport to work before I put them both in. When I run the query the subreport is based on, I get the results of 4 hardware items, but when I run the report I get the subreport listing four different times, listing each item seperatly and like items as many times as they are listed. So for examle I have 1 hub, 1 camera, and 2 computers, it lists the hub and the camera once on two seperate subforms, and it lists the cameras together in two different subforms.
I'm really confused as to what is causing this, and any suggestions are greatly appreciated.