Hi everyone, here is my dilemma.

I am making a "paid time off" from work database. There are three tables I am working with: vacation_days, sick_days, and personal_days. In the vacation_days table, I have three fields: earned_vacation (days earned for the specific month, by accrual rate), used_vacation (days used for the specific month), and balance (which I would like to be updated with the current amount).

I made a query, and selected all three fields and put in an Update statement, but it does not seem to be working. Attached is a screen shot of what I have.

Any assistance would be greatly appreciated!

Download the attached database and check table vacation days then go to query and run query UpdateBalance

Worked perfectly! Thank you!