How do you round a number DOWN (for age)?

[janeewalker]

I have an age field that is calucaled from the date of birth

Age: DateDiff("d",[DOB],Now())/365.25

If someone is 65.6 - it shows 66 - I need this to ROUND DOWN - there used to
be a rounddown feature in Access.

 

[Dirk Goldgar]

I have an age field that is calucaled from the date of birth

Age: DateDiff("d",[DOB],Now())/365.25

If someone is 65.6 - it shows 66 - I need this to ROUND DOWN - there used
to
be a rounddown feature in Access.

When was that? I've been working with Access for quite a few years, and I
never heard of such a function. You may be thinking of the Int() or Fix()
function, but I don't know of any RoundDown() function.

That said, your formula for age is not really correct. Here's a link to
some better ones:

http://www.mvps.org/access/datetime/date0001.htm
Date/Time: Calculate Age of a person

 

[Jerry Whittle]

Age: Int(DateDiff("d",[DOB],Now())/365.25)