I have a table (tblFees) full of fees. the fields I am interested in are:
ID - which is an autonumber
Account - could be many entries in this file with the same account
FeeDate - could be many entries associated with an account
I would like a query that returns one record for each Account.
The ID of the oldest record (based on feedate) in the account
and the Account Number.
I can't figure out a way to get it that way.