Query for latest salary

[Ramesh]

Hi,

I have 2 tables with EmpID, Date and Salary. Can i make a query which will
pick the salary with the latest date for each EmpID?

Thanks in advance for any help

Ramesh

 

[Guest]

You could use MAX([Datefield]) in your query where datefield is the field you
use for the date...

Maurice

 

[Ramesh]

Thanks Maurice.

How do i use the max function on both the tables? i need the latest
considerign the union of the two tables.

Ramesh

You could use MAX([Datefield]) in your query where datefield is the field
you
use for the date...

Maurice

Hi,

I have 2 tables with EmpID, Date and Salary. Can i make a query which
will
pick the salary with the latest date for each EmpID?

Thanks in advance for any help

Ramesh