Calculate form charges

[Jakeman]

I have a table “Quilts”. When a customer comes in I enter “Work Order” information in a form, like date need by, customer name, phone, what type of work & etc. Also, enter an estimated charge for the type of work. There are 9 different charge fields. I have to sum these with a calculator and enter into a field. I would like access to calculate these charges and put result in a field call “Sub Total” for me. I print the form information out for customer and add record with all fields to the table. How can access calculate these charges for me?
It’s a form NOT a query like everything I've seen on Internet.
Thanks for any help given!!

 

[pbaldy]

It is likely that these should be records in a related table rather than multiple charge fields in one table, but:

=Charge1 + Charge2 +...

Perhaps also using the Nz() function if values can be Null.

 

[Jakeman]

I stated they are in the form & not in tabel yet. I need in form so I can print for customer. Need access to calculate befor I print .

 

[pbaldy]

And I gave you the solution, didn't I?

 

[Jakeman]

Sorrry!! I'm new @ access & don't seem to understand you reply. Where would I put this on form (properities) so that results will print on form for customer & then be bonded so to up table?
Thanks & sorry again.

 

[pbaldy]

That was intended to be the control source of a textbox, but that alone would not save to a table (you don't normally save calculated values). If you must:

http://allenbrowne.com/casu-14.html

 

[Jakeman]

Thanks so much for yuur help!!