I have five tables where I want all true values to update to .5, but there is one table in particular where I want the value to stay at 1. Then the calculated totals would sum to another table.
I am trying to make an update query that pulls attendance points from a specific table and multiplies the Boolean value of -1 in half. I want all other points from all other tables to be a value of 1; I'm not sure how to do this.
My Build expression is:
IIf([tblNoLogin]![Attendance]>0,[Attendance]*-0.05,[Attendance]*-1)
But when I run it, an input box appears with "[tblNoLogin]![Attendance]".
Perhaps you have a better suggestion for how I can accomplish this?