How to automatically update an age?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RichyHK25
    New Member
    • Apr 2015
    • 1

    How to automatically update an age?

    How can i programme my microsoft access table to automatically update an age once i have initially put in a birthdate?
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    It's inadvisable to do that, it's better instead to calculate it as needed in a query to make sure the data isn't out of sync.

    Comment

    • nico5038
      Recognized Expert Specialist
      • Nov 2006
      • 3080

      #3
      Checkout: http://access.mvps.org/access/datetime/date0001.htm
      This site holds many usefull topics.

      Nic;o)

      Comment

      Working...