Recent content by Jrmrosebud

Jdraw, All locations make up the system. They are all geographically close to each other. A crew from one of the 12 stations requests the supplies that they need because their supplies need to be restocked. The Lt then pulls the supplies from either stock location. They simply attempt to...

Wayne, That brings up "Syntax error (missing operator) in query expression 'TransactionT.Quantity from ItemT'. In another post you asked for further detail. I have another thread under General. http://www.access-programmers.co.uk/forums/showthread.php?t=276518 That might be the explanation...

So if I have a TransactionTypeT TransactionType Adjustment Initial Inventory Movement Purchase Usage AddRemoveESBuilding Remove Add Remove Add Remove AddRemoveD3 Remove Add Add Add Remove You are suggesting that I something like this? TransactionType Adjustment Initial Inventory Movement...

Jdraw, I appologize for any lack of clarity. We are an Emergency Medical Service and we only purchase supplies for use. There are two locations where the stock is stored. It initially comes into one location (ES Building) and some of it is then moved to the second location (D3). It is then...

Jdraw, I'm assuming that you are including that as if we are selling items? The cost in Item is how much we purchase the item for. We don't sell items after we purchase them, they are moved between two stock locations and distributed from either stock location to one of 12 sites to be used...

Thank you so much. I will work on that and try it.

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 =...

Hi, Thank you for your response. I have realized that the ESBuildingQty and D3Qty fields should be calculated. However, that calculation keeps getting denied by access because it involves another table (TransactionT). How would I accomplish that calculation and also include the specific...

Thank you, I will give that a try and see what I can come up with. :)

IIf([TransactionT]![StockLocation]=“D3” And ([TransactionT]![TransactionType]=“Adjustment" OR [TransactionT]![TransactionType] = “Usage"),[StockLocQtyQ]![D3QtyCalc]-[TransactionT]![Quantity],[StockLocQtyQ]![D3QtyCalc]) I changed it to this and I still get the same error message.

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...

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...