Calculations should be performed when needed in relational databases. Thus,
unless the information from which the "hours spent in a service call" and
"hours spent biweekly" is no longer available, you should calculate the
values when you need them, monthly.

"Calculated Controls" cannot be bound to a Field in a Table for that
reason -- it is a violation of relational database design practices.

Larry Linson
Microsoft Access MVP


"Chely" wrote in message
oups.com...
hi everyone. I know this a topic that has been discussed before but i
search all postings and i can't found an answer to my problem.I know a
litle vba and access and i trying to do a calculated field.Here is my
problem: I need to calculated the hours spent in a service call,and the
hours spent biweekly. THis data have to be stored in a table so i can
retrieve it monthly. How i can do it. Thanks and sorry to ask this
again.