Windows Forum

Ask something
Question Locked

Acess 2007

0 helpful
2 replies

by paul.kimber

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am importing data from a payroll system. This bring in details of each salary increase incluidng the applicable date of the increase. However I want to exclude all but the last record(i.e. the most recent record based on applicable date). I tried 'last' and 'dlast' but either I'm doing it wrong or it isn't the right function. Can anyone help?

2 replies

by rkuhn040172

In Access 2002/2003, you could change it to a Cross Tab query, select MAX and then change it back to a Select query and that was pretty much the fastest, easiest way.

This discussion is closed to new replies.