Pull only the last record

[burrelly]

I have two tables one for employee information, the other for salary.

The two tables are linked via ID.

The salary is constantly updated after each wage review. What I want to do is pull a report that shows the employee name and the last record for that employee in the salary table.

Any idea how to have the report only show the last salary record and not all of them?

 

[pbaldy]

This type of thing?

http://www.baldyweb.com/LastValue.htm