HELP with query expression........

[Guest]

In the old Access database I could use this expression based on the date/time
field, Birth_date.

However...now that our medical school application went online this past
year..the birth date was divided into 3 separate fields (day...month...year)
and the datatype of these fields is number.

How, if possible, can I fix this expression based on this new format?

Age:
DateDiff("yyyy",[Birth_date],Now())+Int(Format(Now(),"mmdd")<Format([Birth_date],"mmdd"))

 

[Rick Brandt]

In the old Access database I could use this expression based on the date/time
field, Birth_date.

However...now that our medical school application went online this past
year..the birth date was divided into 3 separate fields (day...month...year)
and the datatype of these fields is number.

How, if possible, can I fix this expression based on this new format?

Age:
DateDiff("yyyy",[Birth_date],Now())+Int(Format(Now(),"mmdd")<Format([Birth_date],"mmdd"))

Every place you have [Birth_Date] substitute...

DateSerial([BirthYear], [BirthMonth], [BirthDay])