Prev: Skip Records on a Form
Next: Query works on dev db, gets a Run-time error '3073': Operation mus
From: Rolling Hills Helen Rolling Hills on 15 Apr 2010 11:05
how do i format a expression in Access to show age from a birthdate
From: Dirk Goldgar on 15 Apr 2010 11:19
"Rolling Hills Helen" <Rolling Hills Helen(a)discussions.microsoft.com> wrote
in message news:EB910342-D973-4E9A-936A-C1BCBB83D4B7(a)microsoft.com...
> how do i format a expression in Access to show age from a birthdate


See this article:

http://www.mvps.org/access/datetime/date0001.htm


--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: John W. Vinson on 15 Apr 2010 12:11
On Thu, 15 Apr 2010 08:05:01 -0700, Rolling Hills Helen <Rolling Hills
Helen(a)discussions.microsoft.com> wrote:

>how do i format a expression in Access to show age from a birthdate

Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)

--

John W. Vinson [MVP]
From: Hans Up on 15 Apr 2010 12:53
Rolling Hills Helen wrote:
> how do i format a expression in Access to show age from a birthdate

See if this page from The access Web has what you want.

Date/Time: Calculate Age of a person
http://www.mvps.org/access/datetime/date0001.htm
 | 
Pages: 1
Prev: Skip Records on a Form
Next: Query works on dev db, gets a Run-time error '3073': Operation mus