Automatic field update

J

Jonathan

I need a field to automatically show the difference
between two dates in a form. The value should be displayed
in years and should include decimal places. Could anyone
advise please.
 
A

Allen Browne

Set the Control Source of the text box to:
=([EndingDate] - [StartingDate]) / 365.25
where "endingdate" and "startingdate" represent the names of your existing
date controls.
 

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

Count Years 5
rounding problems 11
Decimal places in forms 2
Display of numerical value with decimals in a text box 5
Access Automatically Send a notification email once a record is added 0
Rounding decimal values in forms and reports 2
Input Mask - quick question 6
Using Numbers and decimals 7

Top