I have Access corses up through 329 which I have been working my way through. If you have a table that contains a persons work history for example, from say Associate, Senior Associate, Jr. VP, Sr. VP, President with dates in each position. Is there a course that covers how to make the latest position the "active" position? Thanks, Dave. Great courses BTW, I've never seen better.

---

Reply from Richard Rost:

I'm assuming you have a start date for each position? Just use the DMAX function to find the largest start date, then DLOOKUP the ID from that record for that employee. That will tell you what their current position is.

Or... even easier, just make an IsActive field in that position table and have the user check the current position ON.