Calculating 2 date field

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Sorry...and I need the value to be entered into the table it originates from
 
Sure. In an unbound text box simply put...

=[DatefieldA] - [DatefieldB]



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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DateDiff Troubles 3
Need help on how to pass calculated field from a form to another form 0
Validate the number of checkboxes that can be true 0
How to display calculated fields instead of storage 13
If then for Field 6
Changing sign of a value in calculated field 1
Can I calculate from unbound text boxes? 1
Unbound text box calculation 6

Back
Top