Inventory

[Guest]

We apply and sales products.
I have a table that has the products info and a table that contains how much
we sell and what we have applied. Other table that shows how much product we
purchased. The products we use come in gallon or pounds.
But when we apply certain products one product might be applied in gallons
one day but the next in ounces. How would I show the total sold, total
applied and total purchased in one query? Would I have to show two of the
same products in the product table one in gallon and one in ounces?

 

[Jeff Boyce]

One approach would be to store all the quantity info in the lowest common
denominator (say, ounces for fluid volume). Then you'd use expressions in
your queries to "parse" this into Gallons or any other required unit of
measure. This reminds me a bit of keeping seconds for sporting events, but
displaying as hh:mm:ss.

Regards

Jeff Boyce
Microsoft Office/Access MVP