Sam Summers
Registered User.
- Local time
- Today, 15:22
- Joined
- Sep 17, 2001
- Messages
- 939
Hi Everyone,
I am trying to update the quantity (TotalQuantity) of a field in a table (Aerosols) by selecting the quantity to subtract (NumberSelect) on the form (AerosolQuantityChange).
I am trying to use the SQL below but i am getting the error message that the queries name is not a valid name..........
Ultimately i will also create an update query to add the selected amount to a new location.
Been searching for a while now and not really finding anything?
Many thanks in advance
I am trying to update the quantity (TotalQuantity) of a field in a table (Aerosols) by selecting the quantity to subtract (NumberSelect) on the form (AerosolQuantityChange).
I am trying to use the SQL below but i am getting the error message that the queries name is not a valid name..........
Code:
UPDATE Aerosols SET Aerosols.TotalQuantity = [Aerosols].[TotalQuantity]-[Forms]![AerosolQuantityChange]![NumberSelect]
WHERE (((Aerosols.AerosolID)=[Forms![AerosolQuantityChange].[AerosolID]));
Ultimately i will also create an update query to add the selected amount to a new location.
Been searching for a while now and not really finding anything?
Many thanks in advance