Warning!New windows update come out.

Monday, April 13, 2009

How to get the one before last record in access DB?

I am working on a port movement sheet for my ship and I want to know the port that I have been before the last one. This is for making a crewlist. How can I do that?. I tried using expression builder and multiple queries but it was a long process. There must be an easier way. Please help. I am using Access 2003 by the way.



According to what? A date? If so, sort by that date in descending order, then iterate to the second record.

No comments:

Post a Comment

Help on computer for you