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

Please don't post the same question under multiple topics
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51037