Return first occurrance of a query

[dougmcc1]

Lets say I have 5 rows of data in my database. Each row has 3 fields and the first 2 fields are the same in each row. I need to return the first occurrance of the third field.

So if this is my database:
A B C
A B D
A B E
A B F
A B G

And this is my input:
A B

I need a query to return this output:
A B C

Thanks.

 

[calmwind]

Make a summary query.

In the total row, put
"Group by" under the first column
"Group by" under the second column
"First" under the third column

it should output
a b c

hope that helps