expression builder sum total not entering into table but showing o

[anamque]

I have a form collecting actions taken on accts by the analysts.

i'm collecting -

REDUCED - (analysts enter # of accts being reduced)
REDUCED DOLLARS - (analysts enter $ reduced)
BLOCKED - (analysts enter # of accts being blocked)
BLOCKED DOLLARS - (analysts enter $ amnt being blocked)
total dollars (expression builder adds reduced dollars + blocked dollars)

The expression builder is showing the total dollars on the form - but when I
go into the table - the total dollars is not being added in the table? I need
it to put the sum into the table for that record

 

[Beetle]

I need it to put the sum into the table for that record

Actually, you don't. Calculated values like this should not be
stored in a table, only calculated as need in a query or a
control on a form/report. Storing the value in a table only
invites bad data. If one of the underlying fields that the
calculation is based on gets changed somehow, the stored
value is NOT automatically recalculated. It's also a waste
of disk space and time, since a calculation will usually be
faster than a disk fetch.