Problem in selecting the latest 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 ?
 
O

onedaywhen

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem in selecting the latest date 2
Storing multiple fields in a table from a single form combo lookup 4
editing fields on forms based on more than 1 table/query. 2
Using the latest date in a table as criteria 4
finding a registrationID for an individual. 0
"Cannot open any more databases" 10
update a table from a form 1
Help Designing a Query to Count Classes 7

Top