SELECT DISTINCT or something else.

[shawncraig]

I have a Table with 4 fields in it. Lets say (FName LName MName Age) If
I do a SELECT DISTINCT on FName LName MName I only get those 3 values
returned to me. Is there a way to see all 4 values but NOT include AGE
in the distinction?

 

[guido via AccessMonster.com]

Make your query a 'group by' query (by clicking the sigma/summation button).
FName, LName, and MName would all have "Group By" in the Total row. Change
the Age column to be something else, like Max or First.