Question

Locked

Acess 2007

By paul.kimber ·
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?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Use MAX

by rkuhn In reply to Acess 2007

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.

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums