A Question in MS-Access2003

  • Thread starter what do you mean by display name
  • Start date
W

what do you mean by display name

I want to update and write whatever calculated on From fileds on the field of
a table like tot_ded=ded1+ded2+ded3

all fields are created in table like ded1,ded2,ded3 and tot_ded

please help
 
A

Allen Browne

Put the calculated total into a query, instead of storing it in a table.
That way, you never have to worry about whether the total is correct.

It's dead simple: Create a query that uses this table, and type this into a
fresh column in the Field row:
Tot: Nz([ded1],0) + Nz([ded2] ,0) + Nz([ded3],0)

For more details, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

(By the way, you would proably be better off with a related table to handle
these many values as many records instead of many fields. That solution
would be even easier, and certainly better for creating queries.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"what do you mean by display name"
 
Top