Hi!

I would be very happy if anybody could help me in the following.

I have two tables:

table 1:
Identifyer Date(D/M/Y) Actual description
morning doings 01/02/2004 I stood up at 10:00
lunch 02/02/2004 I ate soup

table 2:
Identifyer Date(D/M/Y) Various description
morning doings 01/02/2004 I did not go to work
morning doings 01/03/2004 I had to call my girlfriend
lunch 02/01/2004 I like cookies
lunch 12/01/2004 The soup was very hot

And I would like to get the maximum record from this two different Excel tables:

table 3 (from tables 1 and tables 2):
Identifyer Date(D/M/Y) Latest description
morning doings 01/03/2004 I had to call my girlfriend
lunch 02/02/2004 I ate soup

Can this problem be hadles in any way?

Thanks:

pontitt

Need more detail, you've got 2 excel tables but where are you trying to link them and how.

With-in excel ?
Using SQL throught some odbc driver ?
Using recordsets in VB ?
Are both table in the same excel file ?

>Need more detail, you've got 2 excel tables but where are you trying to link them and how.

>With-in excel ?
Yes, from two separate excel files <<File1.xls>>; <<File2.xls>>
>Using SQL throught some odbc driver ?
Yes, through ODBC;DSN=Excel files;DBQ=Path of the active workbook
>Using recordsets in VB ?
If it is possible, I would not like to use recordsets (just one SQL query)
>Are both table in the same excel file ?
No, they aren't.

Sorry not to be able clearly explaining my problem. I would just like to get maximum data from two different excel files with one query, as I showed previously.

Thank in advance for your help:

pontitt

SELECT Identifier, Date, Description1
FROM (SELECT Identifier, Date, VariousDescription AS Description1
         FROM Table2
         UNION
         SELECT Identifier, Date, ActualDescription AS Description1
         FROM Table1) DERIVEDTBL1
WHERE (date = (SELECT MAX(date)
                   FROM (SELECT Identifier, Date, VariousDescription AS Description1
                             FROM Table2
                             UNION
                             SELECT Identifier, Date, ActualDescription AS Description1
                             FROM Table1) DERIVEDTBL2
                   WHERE identifier= DERIVEDTBL1.Identifier))