Ok, so I have a sum of weight text box that adds up all the weights of the PO's. That works fine. The name of the text box is SumOfWT. Then next to that text box in the footer, I created another text box to calculate a range of if statements. It will not compile for me, I am looking for help? Thanks
calc: IIf ([Manifest] Like "TRI*", IIf([SumOfWT]<1000,[SumOfWT]*0.42,IIf([SumOfWT]<5000,[SumOfWT]*0.39,IIf([SumOfWT]>=5000,[SumOfWT]*0.37,IIF([SumOfWT]>14000,[SumOfWT]=5180))))), IIf([SumOfWT]<1000,[SumOfWT]*0.28,IIf([SumOfWT]<5000,[SumOfWT]*0.22,IIf([SumOfWT]>=5000,[SumOfWT]=1100,))))
Also when I try to make changes it seems to not save any changes, how do I get around this?
Thanks Nick