Formula to advance to next record HELP PLEASE

[chiplarsen]

I need to create a formula in a query that will look at the next record and subtract it from the current record. There will be thousands of records. This query will be used to calculate hospital readmission rates. I would appreciate any help. The version of Access is 2000. Thank you.

 

[lynchg]

You need to be clearer with what your need is. Do you want to subtract a value in one of the fields on a record from a value in the same field on another record?

'Next Record' could mean a lot of things. No one is going to be able to help you without more information.

 

[JonFer]

I don't understand exactly what you're trying to do but you might want to try a self-join instead where the second instance of the table is restricted to the next admission date for the same patient.

John

http://www.interautomateconsulting.com