This is my Statement:
IIf([TransactionT]![StockLocation]=“D3” And [TransactionT]![TransactionType]=“Adjustment" OR “Usage",[StockLocQtyQ]![D3QtyCalc]-[TransactionT]![Quantity],[StockLocQtyQ]![D3QtyCalc])
When I try to click into another field in the query I get the following error:
The expression you entered contains invalid syntax.
You may have entered an operand without an operator.
What am I doing wrong?
Thank you. :banghead:
IIf([TransactionT]![StockLocation]=“D3” And [TransactionT]![TransactionType]=“Adjustment" OR “Usage",[StockLocQtyQ]![D3QtyCalc]-[TransactionT]![Quantity],[StockLocQtyQ]![D3QtyCalc])
When I try to click into another field in the query I get the following error:
The expression you entered contains invalid syntax.
You may have entered an operand without an operator.
What am I doing wrong?
Thank you. :banghead:
IIF Statement not working
0 commentaires:
Enregistrer un commentaire