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

    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
    Location
    out on a limb
    Posts
    13,692
    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
    Google
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    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 foolproof...is 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
  •