FaeryHigh Posted July 16, 2007 Share Posted July 16, 2007 This probably gets asked all the time, but is there an equation that would allow me to enter a quantity in an item field and in the quantity total it would multiple that number by 8 or 12, etc.? i.e. 1 six pack = 6 beers in the total? Link to comment Share on other sites More sharing options...
MarkWilson Posted July 16, 2007 Share Posted July 16, 2007 Create a table, "Items," with a "UnitOfMeasure" field and a "QtyInPieceCount" field. Items::UnitOfMeasure = pk Items::QtyInPieceCount = 6 Items::UnitOfMeasure = ft Items::QtyInPieceCount = 12 In your original table, use an auto-entered field or calculation field to multiple the quantity of units by the piece count value. 3pk = 18 or 2ft = 24 or 1pk = 6 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6126 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now