My table has three columns, AcctNum, TransDate, SeqNum
I need a query that only displays the last "SeqNum" when an "AcctNum" had
multiple entries on the same day.

For example, my table has the following data:
AcctNum TransDate SeqNum
1234 6/2/10 698
1234 6/2/10 701
1234 6/2/10 705

In this case, I only want the see the one row with the highest "SeqNum"
(which is #705).

Thank you, in advance, for your help, I do appreciate it.