"First" Function

  • Thread starter Thread starter jndickin
  • Start date Start date
J

jndickin

Access 2003
I am missing something about using First in a query. Why wouldn't this
retrieve the first and ONLY the first record for each different Region in
Table1?

SELECT First(Table1.Region) AS FirstOfRegion, Table1.Class, Table1.Item,
Table1.Price
FROM Table1
GROUP BY Table1.Class, Table1.Item, Table1.Price;

Thanks for your help!
 
SELECT Table1.Region, First(Table1.Class) AS FirstOfClass, Table1.Item,
Table1.Price
FROM Table1
GROUP BY Table1.Region, Table1.Item, Table1.Price;
 
Thanks, Wayne. It wasn't the exact answer but you didn't have all of the
info and your answer gave me the clues I needed to figure it out. VERY much
appreciated!
 
Back
Top