Weights and Measure Query

[The Grand Pooh-Bah]

The purpose of my database is to keep track of an inventory. The items are stored in different locations and in containers at those locations. I need to know what items, quantities and sizes are in the containers. I also need to know all the different locations/containers any specific item is located when I do a search or report. I also need to know the total amount of a specific item is in stock I.E. How many total pounds/ounces of rice are in stock.



Items are in fluid wt, dry weight, lengths, ect.
For example I need a query that will add up my total weight of Molasses 3- 14oz + 2- 4 lb 2oz + 6- 128.5 oz and they are all in different containers.

Am I asking Access to do too much?

My test database

[recyan]

1) Off the cuff, Access should be able to handle it.
2) Would be easier for more people to take a look & help, if you upload your db in mdf format.

Thanks

[The Grand Pooh-Bah]

1) Off the cuff, Access should be able to handle it.
2) Would be easier for more people to take a look & help, if you upload your db in mdf format.

Thanks

I tried to save as an earlier version and it said no go. Apparently it has some features that are not compatible with older versions.