Search results
-
J
Syntax Error
This brings up a syntax error: UPDATE ItemT.D3Qty SET ItemT.D3Qty - TransactionT.Quantity WHERE TransactionT.Item = ItemT.Item AND (TransactionT.TransactionType = "Adjustment" OR TransactionT.TransactionType = "Usage"); And when I change it to this: UPDATE ItemT.D3Qty SET ItemT.D3Qty =...- Jrmrosebud
- Thread
- Replies: 3
- Forum: SQL Server
-
J
How to calculate fields with restrictions
Here is an explanation of my database and what I am trying to accomplish. The Question is at the bottom. Any help you can find would be appreciated. Thank you for looking into it! The tables and their fields I have in the database are as follows… EmployeeT EmployeeID – Primary...- Jrmrosebud
- Thread
- Replies: 11
- Forum: General
-
J
IIF Statement not working
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...- Jrmrosebud
- Thread
- Replies: 8
- Forum: SQL Server