how do I update a table column from data entered in form

I have several columns in table that are populated by enterring data via
form. A final column is the sum of all of the data input into the other
columns. How do I get Access to automatically add up the individual columns
to give the sum.

You don't. You use a query to give you the total.

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

BTW, if you adding lots of columns across the table (like you would in a
spreadsheet), chances are that these items should be recorded in a related
table. For example, if you have fields such as:
SpendID
SpendDate
Veges
FrozenFood
Deli
Cerial
the data would be better stored with a related table has has many *records*
for the different types of food, rather than many fields. The related table
would have fields:
SpendID which record in the main table this relates to
FoodType choose from "Veges", "Frozen Food", etc,
SpendAmount dollars for this food type in this entry.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"frank hinchley" frank wrote in message
...
I have several columns in table that are populated by enterring data via
form. A final column is the sum of all of the data input into the other
columns. How do I get Access to automatically add up the individual
columns
to give the sum.