Combining Duplicate Records in a query record into one value

[browninaz]

Good evening all,

I am trying to combine duplicate values in a query record to create one value for the duplicate values. Attached is a copy of the query design I am working with. What I would like to achieve - if column one in record one is the same as column one record two, three, four, etc., I would like to combine these fields into one field.

Thanks as always for any and all help offered.

 

[PaulO]

Sounds like you need to change your Query from a SELECT Query (which will display all records, including duplicates) to a SUM Query (where you can customise grouping levels)