Latest Transaction Report

[Worm]

User Date Limit New Limit Authorised
Ann Clarke 01/05/10 5 500 John
Ann Clarke 03/05/10 10 600 Mary
Fred Smith 01/05/10 5 200 Bill
Fred Smith 03/05/10 10 100 Ellie
Fred Smith 09/05/10 10 100 Ellie
Bill Martin 10/10/10 10 500 Ellie


Bill Martin 06/09/10 10 500 Susan




I want a report that will list the latest transaction only for each User. The File name is Transaction.

Have tried and tried!

TIA

[jzwp11]

Create an aggregate query first

SELECT user, Max([date]) as MostRecentDate
FROM transactions
GROUP BY user

Then create a new query and bring in the query from above and your transaction table. Join the query and table via the user and the date fields. Select the fields you want for your final query.

BTW, it is best not to use "date" as a field name since it is a reserved word in Access.

[Worm]

Wonderful.

Many thanks

[jzwp11]

You're welcome