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.