I have an update query that was working great. Today, it is giving me this error:
I made an append query that can't enter the field [MonthlyShiftsID]. It's a number field, so it's 0. I follow up with an update query that takes the field [MonthlyShiftsID] from the form I'm using and updates the table with it.
It was working great. I'm not sure what happened. Ideas on what I might have done wrong?