Filter out one instance of duplicate records

[hamrthroer]

This one should be really simple. I need to filter out only the first instance of a field that returns multiple instances in a query.
IE (query result I get now)

Example A
Example A
Example A
Example B
Example B
Example B

I need to get back
Example A
Example B

 

[James Dudden]

This should be achieved by adding a Group By to the fields in the query. Click the Totals button on the toolbar or go to View/Totals

 

[hamrthroer]

Thanks bro. I just couldn't pull it out of me memory banks. I only needed one field. For future reference how would you inlude the other fields but group by only one field? I'm fixed for now though. Thanks!