Query returns duplicates

[RobRay]

Hi guys, I have a database with about 20 or so different tables which are all linked through LocationID to tblLocation. I need to make reports for each Location ID (about 150), which lists any info present in each of the 20 tables. I'm sure there's a simple way to do this, but I'm fairly novice with Access.

I've tried different joins as well as just making a report from queries which show individual assets but that produces an error.

I've been trying this query all sorts of ways with DISTINCT row and DISTICNT ID but nothing seems to work

Here's the SQL:
SELECT DISTINCTROW tblLocation.LocationName, tblBleachers.BleacherID, tblBleachers.Cost, tblPlayground.PlaygroundID, tblPlayground.PlaygroundCost
FROM (tblLocation INNER JOIN tblBleachers ON tblLocation.LocationID=tblBleachers.LocationID) INNER JOIN tblPlayground ON (tblLocation.LocationID=tblPlayground.LocationID) AND (tblBleachers.LocationID=tblPlayground.LocationID)
WHERE (((tblLocation.LocationName)="Hampton"));

The output looks like this:


Location BleacherID PlaygroundID
Hampton 10 15
Hampton 11 15

Because there are 2 different bleachers and only 1 playground, it just repeats the playground to fill space, but I'm not sure how to stop this from happenning.

Please help me solve this, I've been trying for so long now and nothing seems to work.

[weekend00]

remove the bleacherID from the select list, and change distinctrow to distinct.

[RobRay]

That didn't fix the duplication issue, just removed bleacherID.
Thanks for assistance though.

I think it would be fine if there actually were 2 playgrounds, then it wouldn't have to repeat, is there a way to have access not repeat the same record for Playgrounds?

[RobRay]

I think I found a way to solve this using subreports.