Query with Distinct on one field only

  • Thread starter Thread starter JohnFol
  • Start date Start date
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.
 
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
 
Back
Top