Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-20-2012, 05:59 AM   #1
WES9659
Newly Registered User
 
Join Date: Dec 2012
Location: Dover, Ohio
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
WES9659 is on a distinguished road
Calculating A Persons Current Age

I am creating a database here at a funeral home I work for. I need to figure out how I can place a birth date in once column than have it calculate the personís age in another part of the form. Would be ideal if each time the form is open that this relationship between birthday and age would automatically update utilizing the current date. I hope I have explained this ok I am really new to this but love the versatility of this program. Please be kind I need more of an in depth explanation in layman terms.

WES9659 is offline   Reply With Quote
Old 12-20-2012, 06:08 AM   #2
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,495
Thanks: 12
Thanked 2,305 Times in 2,256 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Calculating A Persons Current Age

There's no such things as laymans terms when you are trying to write code. And the concept of calculating age isn't that difficult to get your mind around.

http://lmgtfy.com/?q=how+to+calculate+age+in+access
plog is offline   Reply With Quote
The Following User Says Thank You to plog For This Useful Post:
WES9659 (12-20-2012)
Old 12-20-2012, 06:27 AM   #3
WES9659
Newly Registered User
 
Join Date: Dec 2012
Location: Dover, Ohio
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
WES9659 is on a distinguished road
Re: Calculating A Persons Current Age

Thank you for the reply I really appreciate the help have a wonderful holiday season.

WES9659 is offline   Reply With Quote
Reply

Tags
age , automatically , calculating

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending Forms to multiple persons to fill out patsaison Forms 4 11-15-2010 04:18 AM
Attach Mail Message(s) to persons record CarolW Forms 2 07-02-2009 12:07 PM
How can I calculate a persons. john527 Forms 2 04-20-2007 07:33 PM
calculate a persons age code not working. john527 Forms 6 10-24-2006 03:26 AM
Calculating using current date ladydazy Queries 2 03-29-2004 02:52 AM




All times are GMT -8. The time now is 12:22 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World