Calculated Text box

[nick243]

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

[aytee111]

"Compile" intimates that this is done in VBA, although you are mentioning a text box?? If this is in the footer of a continuous form then it needs to refer to fields on the form's record source.

[nick243]

Yes, this is not done in VBA. It is done in the text box. When I run the code from the form button it will not open the form so it gives me compile error but the real problem is a syntax error in the text box of a report. it is a contenuos form. I will look at the fields on my record source.

Thanks,
Nick

[nick243]

I changed the text box to this

IIf ([Sheet1]![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,)))

It still has a syntax error

Thanks,
Nick

[nick243]

This is the syntax error I am getting

[nick243]

This is my Report and field list


Thanks,
Nick

[aytee111]

This should be in the control source and should have an = in front.

You are referring to something called Sheet1 but Access will not know what it is.

In the error it shows "First" but not in your post.

Do these one at a time:
- make a text box with =SumOfWT and see if it displays correctly
- add the first If statement and see if it displays correctly
- etc

[nick243]

I have no idea why it is adding first to the syntax. The control source does not include the word first.

[aytee111]

It looks like there is a bracket missing at the end. Like I say, add these one at a time and get them working.

[nick243]

Ok I am doing them one at a time and it is working. Thank you for the ideas. I just need to go one at a time.

Thanks,
Nick