I am using vb6 and I have a table in access database which contains following fields --
1) account_no
2) account_type
3) trans_date
4) sequence_no
5) deposit
6) withdrawl
7) balance
At the time of first transaction of every account_no of a particular account_type, the sequence_no will be 1. Then after every transaction, the sequence_no field is incremented with 1 for each account_no of a particular account_type and balance field is also changed accordingly. There may be same sequence_no against many transactions of different account_no.

Now, I want to build a report of the last balance of every account_no of a particular account_type i.e. where the sequence_no is maximun for every account_no.
Can anybody help me building the query for the above purpose ? ?