increase a previous field by 5,000

[LearnersPermit]

Good morning, I'm working on a fleet database that requires a Preventative Maintenance flag to appear when users are signing out a vehicle so that users know when the next PM is scheduled for, we use mileage rather than dates.

Not sure that I'm going about it properly. I have a field called Preventative Maintenance which is a number field and I have another field called next_PM_due that I want to take Preventative_Maintenance + 5,000.

Any suggestions on how I would go about doing this?

Thanks

 

[MajP]

I would not store this value, but make it a calculated field in the query. There is no reason to store in the database, you can simply calculate in any form, report, or query to show the next PM.

 

[LearnersPermit]

Thank you MajP. I have tried using =Sum((last_PM)=5000) in a query and on my form without success. Obviously it has to do with my syntax but I haven't been able to find the answer to my problem.

Any further suggestions?

Thanks

 

[PHV]

Why not simply this ?
last_PM+5000

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jges]

last_PM isn't formatted as a text field is it?

 

[LearnersPermit]

Thanks jges - last_PM is formatted as a number field. I currently have next_PM_due as a text field - it has been both a text field and a number field during my attempts to solve the problem.