Access Formula Help

[rickes]

I am lost. I have an access database that I am keeping track of belt changes. I want it to automatically give me the total hours on a belt from the time it was put on to the time it was changed. It looks something like this (top row is column header):

EQUIPMENT BELT DATE HOURMETER REASON TOT.HOURS ON BELT
press 1 upper 12/01/04 100 torn
press 1 upper 1/30/05 150 torn
press 1 upper 3/15/05 250 plugged

What formula would I write in column(TOT.HOURS ON BELT)in a query or in a report to subract record 1 (HOURMETER) from record 2 (HOURMETER) and so on down the column everytime i add a new record to show me the TOT. HOURS ON BELT for each belt changed? For Instance, Record 1 should read 50 Hrs in TOT. HOURS ON BELT(150-100), Record 2, 100 Hrs, Etc.
I need all the help I can get.
Thanks so much..
RICKES

 

[SilentAiche]

rickes,

Welcome to Tek-Tips.

Although there are some Access questions on this forum, there at least five Tek-Tips forums specifically for Access problems. You might have better luck posting your question in one of those (you can copy/paste from here, by the way).

Just a thought - good luck!
Tim

[blue]__________________________________________________
If you need immediate assistance, please raise your hand.[/blue]