Search results

ok, i wasnt originally planning to save the add_total in the database. (i think this is what you mean?) I supose this could be a good thing but how can i have that as a control source and have a formula in the box as well? James.

Hi, thanks for replying, I'm not totally sure what you mean by control? thanks, James.

print screen of form in design view... http://www.jcookdesign.co.uk/access_db_sum_problem.jpg James.

Hi, I changed the [carpet] to "carpet" - no effect at all. :( the code is in the sub form in a text box. it works fine without the sum() around it. here is is again.. =Sum(IIf([type]="carpet",[addtotal]-[addtotal]/100*(Forms!jobs!Frame33),[addtotal])) the text box still displays #error...

Hi everyone! First post here, just looking for some help with a project im working on. I have got a form with a sub form in it which works together to produce and invoice. A discount has to be applied to only one product (if the "type" field is carpet, then a discount has to be applied. (the...