One record from many based upon single field

[kemosabe]

I have a query that returns more than one record per unique field (AssocID).
I would like to return only 1 (first?) record per unique field. Is there an
easy way to do this? Thanks!

 

[Michel Walsh]

SELECT AssocID, LAST(otherField1), LAST(otherField2), LAST(... )
FROM somewhere
GROUP BY AssocID




Vanderghast, Access MVP

 

[John W. Vinson]

I have a query that returns more than one record per unique field (AssocID).
I would like to return only 1 (first?) record per unique field. Is there an
easy way to do this? Thanks!

SELECT TOP 1 AssocID, thisfield, thatfield, theotherfield
FROM <whatever>
ORDER BY <some field>

 

[Michel Walsh]

Ah, I haven't understood the question like this, and indeed, that returns
ONE record from the whole table.


Vanderghast, Access MVP

 

[Michel Walsh]

Four possible solutions at http://www.mvps.org/access/queries/qry0020.htm


Vanderghast, Access MVP