Simple Addition

[RichGags]

I have a table which Ive imported from an old Q&A Symatec database. Im trying to program my fields like I used to have.

Lets say I have 3 fields named "music", "Props" and "total"

How do I make the TABLE automatically update the "total" column to equal "music"+"Props" and where does this command go?

Thanks!

 

[RV]

Updating will have to be done by creating an UPDATE query and running it.

But why would you store calculated data in a table?
You don't need the column "total".....

RV

 

[RichGags]

Ok, then how would I do it on the Form? I thought I needed the calculated value in the table so that when I print a contract, it will pull the value of that field and put it to the report.

 

[RichGags]

No?

 

[Pat Hartman]

In the controlsource of a control on a form or report -

=Nz(Music, 0) + Nz(Props, 0)

 

[RichGags]

Thanks! Working now....