Sorry how to determine quantity onhand of the products

DLookup

If there is more than 1 supplier, you could use:

SELECT SUM(column_name) FROM table_name WHERE condition;

-Raymond

Ya using dlookup I can get the specific casing name or default casing name, as the customer pricing video of RICHARD.
But what I need is the quantityonhand of a product with different casing name.
I came across found the way,I have got used to using product code to a product
For instance K7P2160 (bedsheet with rawmaterialK70 ,bedsheet size 160 and 2 pillow case) defalult casing "Inora" and K7P2160HG this with specific casing "HAGU"
So I just type the product code determining qty sentproduct-enter to warehouse...etc
Thanks for the attention

hopefully it wil work very well
the same product but different casing name

Oh no it can not be.
I only can create a new "product name"
I am sorry.
Using dlookup as in the customerpricing video
I can get a product with new casing name  but how to diminish  the product in the ware house

Inventory
Manage Rental Inventory

Oo my god....I think too much
The product name has two casing name , by using the dlookup the casing name (whatever default or new casing name from CUSTOMERPRICING VIDEO) is only to show in the invoice and the product name (is the same) to get the quantity onhand ia just using the APPEND QUERY
Is this correct?
Sir ALEX THANK YOU FOR REMINDING ME