Limiting Query Results to Unique Values

[orangeman2003]

Hi,



technically nothing is wrong with my query but my issue is related to repeating rows in a query. As my screen shot shows, I have a relationship between something called 'common name', 'filename' and 'system'. The problem is that in a report, I am hiding the 'filename' field because it is too granular to show. However, Access still displays a record based on the number of files it maps to. For example, I have a 'common name' called 'TADDM'. This has 7 files associated to it and 1 system. In my report access lists this record 7 times (as it should) even if I hide the 'filename' field. I am trying to get it so that where multiple records exist for the 'filename' entity, access only shows a unique value. Select DISTINCT will not work in this instance because each filename is different.

Is what I want to do even possible?

If you take the 'TADDM' example in my screen shot essentially I want this record shown 1 time, not 7.

Thanks!

[June7]

If you don't want that field to show then why is it in the query?

Maybe do a report grouping on the CommonName field and don't even bring Filename into the report. Size the detail section to 0 or set it not visible.

[Demerit]

Note that in a query, all associated records for an item must show up. A query is not meant to be visible to users. So to have "TADDM" appear once, this can only be done in the report by grouping Tbl_Files.CommonName Just like June7 said. Of course thats what you want users to view it like.