Need to update a field to '0' that is running off a query

[LanieB]

HELLO!



I have a form we are entering scores into. The points available depend on how many bills there were. In a query I have the points available for that element multiplying by the number of bills. In the form I need the user to be able to 0 out this field in the case that element is not applicable. Right now it appears like

Points Available: [element]*[numberofbills]

Is there something else I can write in there to let it know that a 0 is acceptable as well? In the entry form this field if locked and will not allow me to 0 it out.

[pbaldy]

I think this will help:

http://allenbrowne.com/casu-14.html

[JoeM]

If "Point Available" is a calculated field in a query, you can hard-code numbers into it. Hard-coded numbers can only be stored in underlying table fields.
You could add another field to your table, some sort of override field, and then have htem update that, and have your calculated field include that in its calculation, i.e.

Points Available: IIF([override]=0,[element]*[numberofbills],0)