only showing the first in a group

[ovie52]

my query results in a situation like this:

name letter color

keith a blue
john b green
kate c yellow
kate c yellowx

i don't want to see the row which has 'yellowx'.

I want the query to only show me the first row in a group of rows where 'name' & 'letter' are the same.

Can anyone help?

 

[raskew]

A totals query, e.g.

SELECT tblColors.name, tblColors.letter, First(tblColors.color) AS FirstOfcolor
FROM tblColors
GROUP BY tblColors.name, tblColors.letter
ORDER BY tblColors.letter;

Using Max/Min or First/Last will do this for you, but a question would be "...in choosing between 'yellow' and 'yellowx', do you want the first response submitted, the longest name, or what?"

Bob

 

[blom0344]

Hello Ovie,

SELECT Table.fld1, Table.fld2, First(Table.fld3) AS FirstOffld3
FROM Table
GROUP BY Table.fld1, Table.fld2;

******************************************************

In this example fld1 = name
fld2 = letter
fld3 = color