I need a value entered from a form to be changed before being written in a table.
The users enters a value in "Quantity Issued" in a form, which is then written in a field "Quantity" in a table.
Now, I need the value entered (say 9) to be written as (-9) in the table. Is it possible to multiply it by (-1) or add a (-) before the number?
Thanks
Mike
The users enters a value in "Quantity Issued" in a form, which is then written in a field "Quantity" in a table.
Now, I need the value entered (say 9) to be written as (-9) in the table. Is it possible to multiply it by (-1) or add a (-) before the number?
Thanks
Mike