Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add 5000 to field

Status
Not open for further replies.

LearnersPermit

Technical User
May 30, 2001
70
CA
Good morning, Sorry for posting in both tables and forms, but I think that this is a basic question that I should know the answer to, but can't get it to work.

I have a field in my vehicle table called Preventative Maintenance that holds the mileage that the last PM was completed.

Now I want to add a flag on the form that alerts the user when the next PM is due. I have tried =Sum((tblVehicle.last_PM)+5000) without success. I have added the , and removed it several times.

Any suggestions to how I can correct this problem.

Thank you.
 
What about this ?
last_PM+5000

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top