New To Access

[BigMacCy]

Hi there,

New here to the forum, and a very new beginner to Access. I would like some help with a formula that I am trying to add to my table and or form to calculate the following :

I have a table that contains various products for example ABC RED WINE 1x12x750ml . I would like to enter a value of eg 15 as the quantity on hand and the result should give me the following : FULL CASE : 1 UNITS 3 . I have tried to create a calculated field in my table but the numbers are wrong. The formula is calculating the following : 1x12x15 . I know that this formula should be 15 / (1x12) or something to that line.

Any help would be appreciated.



Thank you
Sotiris

[June7]

Why would the formula be 15 / (1x12)?

This makes no sense to me.

How do you derive 1 case and 3 units from "ABC RED WINE 1x12x750ml"? and an input of 15?

[BigMacCy]

Hi June7

Sorry if I didnt make it clear enough ... I count the stock in warehouse in units ... so in the example I would count 15 units . But I would like in my reports to give me how many full cases of product I have and how many "open" cases I have. So my physical count would be 15 for example, so in essence I have 1 Full case of wine and 3 bottles in an open case.

Hope that make is clear.

Thank you
Sotiris

[June7]

Should probably save discrete data elements in separate fields. Something like:

ProdID	Product	ProductSize	SizeUnit	Units	GrossUnit
1	ABC Red Wine	750	ml	12	case
2	Something	2	lb	1	each

Even then, I doubt what you want will be simple.