Trouble with Expression

Jul 14, 2011
Reaction score
I am working on an inventory database needed for medication samples for an indigent clinic. I am new to Access and know my limits so I did begin with a template.
I would like to be able to maintain a perpetual intentory. There are several transactions that are possible and I have a table which reflects this (samples, sample distribution, original balance, expired meds). Where I have run into trouble is that I need to distinguish between the quantity of the transaction and the actual quantity which affects our inventory. For example, expired meds may be a quantity of 7, but the actual quantity for our inventory is -7. I do not know how to write an expression that expresses each transaction.

So far I've got, which is not yielding a quantity:
Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition",[Inventory Transactions]!Quantity,-([Inventory Transactions]!Quantity))

Any further help in the right direction would be much appreciated.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question