Query with Distinct on one field only

J

JohnFol

For the "distinct" field, there may be multiple records. How would Jet
automatically know which of the records you want returned?

ie
Fred 01
Jo 02
Peter 05
Fred 07

Should it be Fred 01 or Fred 07 returned?

I would suggest you need a group by query.
 
B

Bob Dzimbowski

Hi do I make a query that has a number of fields, but I only want 'distinct'
to be applied to one particular field.

Thanks
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Distinct 4
SELECT DISTINCT only on some fields but display all fields (AC 200 3
Limiting multiple results in query 7
Combine info from queries 0
Eliminate repeat values in one field 7
SELECT DISTINCT query 8
Query Help, Works in Excel But not Access 3
Query structure and distinct 7

Top