Contact Info Tel: 916.726.5675
-Collapse +Expand
Access
Search Access Group:

Advanced
Access To/From
To/FromCODEGuides
Access Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:
   ► MB Lobby ► Microsoft Access Board ► MS Access Interactive Topic   Print This     

Short Question of Time?

Short Question of Time? in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: Question   Short Question   Short Question of  
 Short Question of Time? Post ID #4562, 1 reply 12/11/2001 10:56:00 PM  
billmanhart
 (Inactive)
San Bernardino, California
In an Access 97 database I am creating, one of the fields in a table is DOB (for Date Of Birth). I need a formula or something to compare the birth date with the current date and always get the person's current age in years. This would probably be in a query.
 Posted 25 years ago (Thread Starter)
Comment Quote
About billmanhart
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
Post ID #4562, 1 replies
Thread Started 12/11/2001 10:56:00 PM
View Counter=1347
Location=San Bernardino, California  
Joined=25 years ago   MB Posts=7  
Most Recent Post
 Re: Short Question of Time? 12/12/2001 7:28:00 AM  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
You will want to use something like the following in a calculated field.

txtAge = DateDiff("yyyy", CDate(txtDOB.Text), Now())

the above code does not take into account dates between the first of the year and the DOB. You could take this into account by comparing the birth date in the current year to the current date.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com
 Posted 25 years ago
Comment Quote
About Daniel Fought
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.
Post ID #4566 (Level 1.1)  Reply to 4562
Thread Started 12/12/2001 7:28:00 AM
View Counter=2
Location=Home office in Fresno, CA. 
Joined=24 years ago   MB Posts=401   KB Posts=12   KB Comments=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1114A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #4562 Counter
1347
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com
LEGACY DATA:
(from PrestwoodBoards.com)
CONTACT US:
Office Hours: 8am-5pm | Mon thru Fri 
916-726-5675 (office)
8421 Auburn Blvd, STE 256
Citrus Heights, CA 95610


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]  

 
↑