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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"))
 
jacqueline said:
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"))
Click to expand...

Every place you have [Birth_Date] substitute...

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