C
Coles
I have a function for working out the age of a person based on their date of
birth as follows:
=DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))
It works perfectly well for each record if I place it in a query but if a
put it as the default value on a form it will only work on the first record.
Can anyone enlighten me?
Many thanks,
Colin
birth as follows:
=DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))
It works perfectly well for each record if I place it in a query but if a
put it as the default value on a form it will only work on the first record.
Can anyone enlighten me?
Many thanks,
Colin