Group by Function & Min

[Guest]

How do I:
1) Group a list of transactions by Item#. There are multiple Item# with
several transactions. Group_by???
2) Select the earliest date for each transaction in the group?

My output will give me every item with the earliest date date each item was
purchased.
thx

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), there is a small Access sample
database called "MaxQueryProblem.mdb" which shows this. Just substitute Min
for Max.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L