how i can transfer the data that i calculated in a form to a table

  • Thread starter Thread starter Chely
  • Start date Start date
C

Chely

i created a form to add data to a table. I have a column it calculates
how many hours take me to do a work. I have Start time column and
Finish time column. I works in the form, but the data doesn't show in
the table. What i have done wrong? Thanks
 
This is discussed all the time. Read the previous posts before adding a new
thread please.

You don't store calculated values in the table. You store the two numbers
to perform the calculation (start and stop time) then you calculate in an
unbound field in your forms, queries or reports. If you stored this value,
then made a change to the start time or the stop time, your stored
calculated value would be wrong.

Storing a number like this is redundant, often results in wrong data, and is
much slower to read a number from the disk than to calculate it on the fly.

I'd suggest you read the previous posts on the topic. The easiest way I
have found is to go to www.google.com, click the "groups" option, and enter
a search string like the following...

microsoft.public.access store calculated value table
 
Back
Top