Calculating Percentage

[robsworld78]

Oh if I can't figure it out I'll probably post the db, don't want to do that just yet, its still a mess and you probably wouldn't know where to start.

[apr pillai]

Simplify the formula by adding three unbound textboxes and organizing the source value locations into them seprately like:

Textbox name: X
           =[OrdersOrdersSubform].[Form]![CoolerVolume]

Textbox name: Y
           =[OrdersInventorySubform].[Form]![SumOfVolume]

Textbox name: Z
           =[VendorInventoryLevelSubform].[Form]![SumOfVolume]     

Textbox name: Result
           =[X]-[Y]-IIF(Nz([Z],0)>0,Z,0)

The Nz() function checks for Null value in textbox Z, if Null then takes 0 as it's value otherwise takes the original value in Z.

The Usage of IIF() is IIF(Condition, True, False).

Example:
T=2004
= IIF((T MOD 4)=0, "Leap Year","Not Leap Year")

[robsworld78]

Thanks for that! I'm currently just starting to rebuild the db from scratch, doing some major changes to how it works so I thought I would start fresh which allows me to fix things I know needed fixing. Once I get to that point again I'll give that a go and let you know how it worked.