getting max date of records with same SalaryId but less than curren

[Guest_imported]

I have a table that has the following fields; SalaryId, FTE, Date.

There can be more than one record per SalaryId but only one record with a particular SalaryId-Date combination.

What i need is a table that has fields; SalaryId, FTE, Date, Max Date less than current date for this SalaryId.

Example:
Current Table
Salary, FTE, Date
1, .65, 1-5-01
1, .73, 5-5-01

New Table
Salary, FTE, Date, MaxDate<Current
1, .73, 5-5-01, 1-5-01.

Please help me!!!!!!!

 

[Guest_imported]

Woops, i really want the min date > current.