store calculated values

[Jackie]

i am attempting to add several fields together to add to
a table. I have the macro attached to the fields and the
expression set up to add the fields together for this
total. however, everytime i enter information into one of
the fields being used in the calculation i get the
following message: The object doesn't contain the
automation object "timecards" (which is my table name)
The component doesn't make the property or method
available for automation operations...,

Does anyone know what I am doing wrong....
all I want to do is add several fields together and
update an underlying table with the individual fields as
well as the total....

Thanks for any help you can provide

 

[Van T. Dinh]

We don't normally store calculated values in Table(s). Calculated values
should be re-evaluated whenever you need them!

I am not sure from your description whether you are working on a Form or
not?

 

[Jackie]

I am creating a form that will be used for time sheet
entry. each day has 5 different columns that can
information entered into. I want to put a column at the
end that will add the 5 different columns together to
indicate the total hours worked.
I pretty much want to set this form up like an excel
spreadsheet but i want easy entry for the user. I then
intend on creating a report with the detail and a
possible export of the information so I need all the
individual as well as totals written to a table.
Is this not possible?

 

[Rick Brandt]

I am creating a form that will be used for time sheet
entry. each day has 5 different columns that can
information entered into. I want to put a column at the
end that will add the 5 different columns together to
indicate the total hours worked.
I pretty much want to set this form up like an excel
spreadsheet but i want easy entry for the user. I then
intend on creating a report with the detail and a
possible export of the information so I need all the
individual as well as totals written to a table.
Is this not possible?

Neither the creation of a report nor the need to export the data requires that
you store the calculations in your table. Do the calculation in a query and use
that for the report and the export routine.