Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    Question Unanswered: Age calc in query ok in 2003 not working in 2010

    I have used the following in queries to calculate age in Access DBs through 2003 and it worked without poblem.

    AgeCalc: Int((Date()-[DOB])/365.25)

    Starting with 2007 and now 2010 the query shows "#Error" when it first opens but will show correct age if sorted on the age column. Any ideas???

    (I have VB code to calculate age but some of my clients restrict any VB code)

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Why don't you use the DateDiff or DateAdd function ?
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts