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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top