Filtering Queries with Multiple Entries

[JVermast]

I have a query that feeds a report. This report shows a "Set" and the "Charge Numbers" associated with it. Each set could have a possibility of more than one set of IT numbers. This means there could be say 2 entries for set "D7" and IT numbers for both of them.

As a result when I run the query, and say the set has 2 Charge numbers, it will bring back 2 results, with 2 charge numbers on each of them, which is correct. So if a set had 4 charge numbers assigned to it, 4 results would show with 4 charge numbers for each result.

Is there any way I can make it only show one of those results as they are identical?

I know this is confusing, bare with me

 

[ejstefl]

Try changing your query to a totals query and using "Group By" for the set and charge fields... this should select only unique combinations of sets and charges.

 

[JVermast]

Try changing your query to a totals query and using "Group By" for the set and charge fields... this should select only unique combinations of sets and charges.

What would I set the other fields to? When I erase the "Group By" (default) they get set to "Expression" and the query doesn't work.

 

[ejstefl]

Set it to Group By for all fields...

 

[JVermast]

Alright I did that but it changed absolutely nothing.

 

[ejstefl]

You could also try right clicking on you query and going into properties. Set the UniqueValues or UniqueRecords property to Yes and see if that works. Look at the help for both UniqueValues and UniqueRecords to see which one you'd need to use.