Use a query with this forumula

[Guest]

I need to use a query using this formula to update a field. How would I go
about converting this into a query?

(date1 - date2)/(86400*365.25)

 

[Guest]

First of all, you should seldom update a field with values derived from other
fields. It's almost always better to run the formula as needed in a query,
form, or report. What happens if someone changes the value in Date1 but
doesn't update the table? Inconsistant data.

Second what kind of fields are Date1 and Date2? What kind of answer are you
looking for: years, minutes, seconds?

365.25 is kinda close in accounting for leap years; however, Access has some
very accurate date functions such as DateAdd to do the job.

 

[Guest]

For this database we can't have birthdates in it so I am converting them to
an age.
What I need to do is derive the age from the date of the assessment (date1)
and the birthdate of the person (date2).

Does Access have a build in fuction for leap years?

Any suggestions would be great.

 

[Douglas J. Steele]

See http://www.mvps.org/access/datetime/date0001.htm at "The Access Web" for
how to calculate age.