Unanswered: Access the Previous Record with Missing ID Number
I am trying to perform calculations in a report using data from the current record and the previous record to it. I found this MS article which helps me access the previous record and that works fine. The problem is if I delete a record from the table then that ID number will be missing so record numbering will be similar to 1,2,3,5,6 etc missing 4. If I then run my report I get blank fields because on the record which looks back at the missing record it won't find the previous ID in this case ID 5 - 1 should be 4 which isn't there.
Do you know of anyway I can get it to look back until it finds the previous ID (or just the previous record) even if several rows are missing?
If you need me to explain that a bit more clearly please ask.