#Error Issue

[denileigh]

Hello all,

I have a form with a Text Box in the detail (Text100) which contains the following =[QuoteMaterial]/(100-[MarkUp])*100 and it works fine however I am trying to get a total of that in the Form Footer. I've placed a Text Box there which contains =Sum([Text100]) but it isn't working?

Any help is greatly appreciated! Thanks so much in advance!

 

[pbaldy]

You can't sum a calculated control. You can sum the calculation.

 

[denileigh]

I'm not sure I understand. I'm self taught and only mess with the database every few years so I forget how I figure out how to do something. Do you mean I need to do the calculation in a query then total the field?

Thanks so much for your patience and help!

 

[pbaldy]

That's another way, yes. What I meant was:

=Sum([QuoteMaterial]/(100-[MarkUp])*100)

Putting it in the query is probably easier though.

 

[denileigh]

Ah - the problem with that is different lines have different mark-ups depending on the vendor or possibly none if it's ours. So.....query??

 

[pbaldy]

I think the formula would account for that, but putting it in the query is probably more efficient anyway.

 

[denileigh]

It worked!!!!!!!!!!!!!!!!! Ty!!!!!!!!!!!!!!!!!!!!!! You rock!!!!!!!!!!!!!

 

[pbaldy]

Happy to help!