Query to return unique or distinct rows based on 2 fields (columns)

[JeffChr]

I have a table with perhaps 10 columns or so. I'd like to return all of the columns but only some of the rows. The rows I would like to select are unique or distinct rows just looking at two of the columns. Can an Access query do this or do I need to develop something in VBA?

[pbaldy]

What value do you want for the other fields? Create a new query and add all 10 columns. Click on the Totals icon on the ribbon. Leave Group By on the 2 fields and change it to Min, Max, Sum or whatever for the others.

[JeffChr]

Group By did the trick. Thanks.

[pbaldy]

No problem.