Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012

    Unanswered: Access 2000 DOB to Age

    I am new to this forum and have read some solutions to date of birth to age but it was for Access 2003. I am using Access 2000 and need to make a field to track ages of clients. Could someone point me in the direction I need to go. I would also be interested in some Access 2000 Templates to view for ideas.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    store the clients date of birth as a datetime datatype

    then whenever you need to find the age of someone you use the appropriate datetime function, in this instance confusingly called dateadd
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    There's nothing in any 'accurate age' hacks I've seen that would work in 2003 but not in 2000.

    HEre's one site with some 2000 templates:

    ShareMe - free Ms Access 2000 Templates Freeware download

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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