Let me get this straight. I have to convert the weights into metric equivalents in order to add them up. then convert them back to standard weights? If this assumption is correct then I also need to use a constant metric equivalent such as grams?
So for 50 pounds 7oz I would enter it as...
I added some items to the inventory and did a quick duplicate query to show them. While entering the size of items I ran across some items that are in pounds and ounces I.E. 4lbs 3oz. I put the unit value at pounds but this will be a problem since there are ounces to add also.
The purpose of this database is to keep track of an inventory. Items are stored in different locations and in containers in the locations. I need to know what items/quantities/sizes are in the container. I also need to know all the different locations/containers any specific item is located...