Query for latest salary

R

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
 
M

Maurice

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

Maurice
 
R

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

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

Maurice

Ramesh said:
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
Click to expand...
Click to expand...
 
Top