Update field

M

Margie@ABI

I have created a small database in Access 2003 that is linked to a form in
InfoPath to track vacation days. Currently, I cannot find a function that
will update the field for total days already taken when new information is
submitted from the InfoPath form. I am very inexperienced in both Access and
InfoPath and amazed that I was able to even build this form/database so far.
Can anyone give me a recommendation on how to update this field?
 
K

Klatuu

Total Days is a Calculated value. Calculated values should not be stored in
a table. They should be calculated whenever you want to present them to a
user in a form, report, or query. Calculated fields waste space, take longer
to retrieve from disk than the doing the calculation in memenory, and are
prone to becoming incorrect if any errors occur.
 
K

Klatuu

Since I don't know info path, I can't say for sure, but if you are working
with an infopath form, I would say yes.
 
Top