Problem in selecting the latest date

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am using Excel 97 Microsoft Query.

There are a number of tables from SQL Server for
analysis. For the same Registration Number, there are
more than one Registration Date (One in 2000, One in
2001 ...). I would like to know is it possible for me to
retrieve the row with latest date ?

However, the Registration Number is in a table different
from that containing the Registration Date. And
there are a number of tables linking between them. There
is no direct linkage between the tables that containing
the "Registration Number" and "Registration Date".

Is there any suggestion ?
 
There is no direct linkage but there are a number of tables linking
between them? In which case, you will have to post the relevant
tables' schema e.g. what are the key columns which link the
intermediate tables?
 
Back
Top