Set a field to negative number

[reidhaus]

I have a transactions table with a simple "units" field that I want to use to determine inventory. When items are received the # entered in "units" is positive; however, I'd like to create another form for those same items once they ship and set the "units" field to a negative number so when I run a query I can sum-total the items in stock. Is that possible?

 

[missinglinq]

I'm not sure how you plan on implementing this but zero minus a number will give you the negative of the number. In VBA:

Me.UnitField = 0 - Me.UnitField

or a calculated field in a Query:


CalculatedNegativeField: 0 - [UnitField]

Linq ;0)>