Convert Expression Calculation into Data Table?

[jdean]

Hello all, I'm quite new to Access. I've read many Access tutorials and site but I have yet to found the solution for my problem. So here it is (pardon my english):

Field AmountTotal is
=(Nz([AmountSubTotal])+Nz([AmountSH])-Nz([Discounts]))

I manually input AmountSubTotal, AmountSH and Discounts. I expected an automatic calculation for AmountTotal.

In "Form view" I get the result of AmountTotal that I wanted. But the calculation result doesn't get recorded in my field data table AmountTotal. It just shows blank.

How do I record this automated results into my original table?

Thanks in advance!

 

[llkhoutx]

The control source for "Field AmountTotal " should be

=(Nz([AmountSubTotal])+Nz([AmountSH])-Nz([Discounts]))


Why not put AmountSubTotal, AmountSH and Discounts in unbound textboxes, using those name as textbox names, so that the data can be changed or corrected if you make a mistake?

Then the control source for "Field AmountTotal " should be

=(Nz(Me![AmountSubTotal])+Nz(me![AmountSH])-Nz(me![Discounts]))

 

[jdean]

Yes, my control field is
=(Nz([AmountSubTotal])+Nz([AmountSH])-Nz([Discounts]))

It doesnt work. Let me clear up a lil bit more. I have NO programming script at all on my form. Not sure if I really need one.

I have Order Table and made auto Order Form.
in Order Form, Control field for AmountTotal is
=(Nz([AmountSubTotal])+Nz([AmountSH])-Nz([Discounts]))

In Form view, it showed the result that I wanted. But when I checked my Order Table, the result didnt get recorded (blank).

The question is how can I save the calculated result into my OrderTable?

 

[Rich]

You shouldn't store a calculated value, there's no need to either.

 

[jdean]

Lets just say somehow I really really need to save the calculated value. I know its a bit redundant in term of programming effeciency. But is there actually a way to do that? If there is, how?

Thanks!