totalling fields in a table/form

[Lee]

I use Access2000 in a Windows98 environment. I am trying to use field 18 to generate the total of the values in fields 1 thru 17. I am using the expression :

=[field1]+[field2]+[field3]+[field4], etc.

Why does this not result in the total being entered automatically in field18??

 

[David Mack]

Create a query, then base your form on the query instead of the table.

In the query do not add the column 18 table item, instead create an expression like this on the QBE design grid:

Column 18: [Your Table]![Column1]+[Your Table]![Column2]+[Your Table]![Column3]+ etc...

Enter a text box on your form and place the control to point at "Column 18" on the query as the source.

Open the form and change your column data...the total will change automatically

Dave Mack Saratoga, NY