Calculated Query using date field

[Kathy W]

I would like to calculate a persons age on March 1 2002 using the date of birth field. I have entered the expression DateDiff("yyyy",#3/1/02#,[Birthdate]) This gives me the correct age in years with a minus sign in front ie -25, but does not differentiate between birthdates before or after March 1 2002. I would appreciate some help Thanks. Kathy

 

[Liv Manto]

iif()

 

[Kathy W]

So where do I put iif() ? Thanks for help

 

[Alexandre]

What do you mean by "does not differentiate between birthdates before or after March 1 2002. "?

For example:
if [Birthdate]< #3/1/02# then
msgbox "Was not born at that time"
else:
msgbox "Is " & DateDiff("yyyy",#3/1/02#,[Birthdate]) & " years old"
end if

Alex

[This message has been edited by Alexandre (edited 02-25-2002).]