How to Max(Date) ?

[Jan Nademlejnsky]

I have several databases in several directories. Each database contains
fields Item and Date. I would like to collect the last date from each
database
into a single document, preferably Excel.

Example:

.....\Data1\Test.mdb: Item1, 03/01/25, Item2, 03/02/24, Item3, 03/05/31
.....\Data2\Test.mdb: Item1, 03/01/27, Item2, 03/03/23
.....\Data3\Test.mdb: Item1, 03/01/25, Item2, 03/04/24, Item3, 03/05/31,
Item4, 03/07/31

Required tabular results:

System: Data1 Data2 Data3
Item: Item3 Item2 Item4
Update: 03/05/31 03/03/23 03/07/31

Appreciate your help.

Thanks

Jan