Inventory

M

MWeber

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top