G
Guest
I have a form and would like field C to be automatically calculated in a
form. The formula being Datefield A - DatefieldB = field C
can this be done?
form. The formula being Datefield A - DatefieldB = field C
can this be done?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Sorry...and I need the value to be entered into the table it originates from
R
Rick B
Sure. In an unbound text box simply put...
=[DatefieldA] - [DatefieldB]
Rick B
=[DatefieldA] - [DatefieldB]
Rick B
R
Rick B
Nope.
You would not want to store a calculated value. When you need the value,
just recalculate it.
Storing the value would lead to all kinds of trouble. What if you changed
one of the dates, but forgot to fix your calculated field?
Search through here and you will find a hundred posts explaining why you do
not store a calculated field in a table.
There are some exceptions, but I can't think of a case where subtracting two
dates would be one of them.
Rick B
You would not want to store a calculated value. When you need the value,
just recalculate it.
Storing the value would lead to all kinds of trouble. What if you changed
one of the dates, but forgot to fix your calculated field?
Search through here and you will find a hundred posts explaining why you do
not store a calculated field in a table.
There are some exceptions, but I can't think of a case where subtracting two
dates would be one of them.
Rick B