Thread: Average Age
View Single Post
  #4  
Old February 12th, 2010, 07:05 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
  
Posts: 1,610
Default Average Age
Correction. First expression should have been:

DateDiff("m",[DoB],Date())+IIf(Day([DoB])Day(Date()),1,0)

KenSheridan
Stafford, England

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201002/1