store calculated values

  • Thread starter Thread starter Jackie
  • Start date Start date
J

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
 
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?
 
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?
 
Jackie said:
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?
Click to expand...

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