I am trying to figure out how to write a query that groups on Max Date then Max Amount. Below is example table and what I want for results.
Table1
AcctNum Thing Date Amount
1234 Cat 1/1/05 200.00
1234 Dog 1/1/05 300.00
1234 Fish 5/2/04 200.61
1234 Bird 3/1/05 600.51
4321 Dog 2/9/05 200.55
4321 Fish 2/9/05 300.99
4321 Worm 5/1/04 200.25
4321 Pig 3/1/05 600.01
Results Want
1234 Dog 1/1/05 300.00
4321 Dog 2/9/05 200.55
Table1
AcctNum Thing Date Amount
1234 Cat 1/1/05 200.00
1234 Dog 1/1/05 300.00
1234 Fish 5/2/04 200.61
1234 Bird 3/1/05 600.51
4321 Dog 2/9/05 200.55
4321 Fish 2/9/05 300.99
4321 Worm 5/1/04 200.25
4321 Pig 3/1/05 600.01
Results Want
1234 Dog 1/1/05 300.00
4321 Dog 2/9/05 200.55