expression builder sum total not entering into table but showing o

A

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
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Names not showing in Expression Builder 6
Sum fields in a table 1
Calculating Fields in a form 2
Expression back to table 1
Inserting Calculation / Expression in a Form 2
subform total behaving strangely 2
Expression Builder basic question on syntax / Or / how to incorporatea SQL query into a textbox cont 16
Form/Table Problem (form doesn't input info into table) 1

Top