What formula do I use to calculate age in Microsoft Access 2007
J Jeff Boyce Aug 1, 2009 #2 Try searching on-line or at mvps.org/access for "age". Regards Jeff Boyce Microsoft Office/Access MVP
Try searching on-line or at mvps.org/access for "age". Regards Jeff Boyce Microsoft Office/Access MVP
J John W. Vinson Aug 1, 2009 #3 What formula do I use to calculate age in Microsoft Access 2007 Click to expand... DateDiff("yyyy", [DateOfBirth], Date()) - IIF(Format(Date(), "mmdd") > Format([DateOfBirth], "mmdd"), 1, 0)
What formula do I use to calculate age in Microsoft Access 2007 Click to expand... DateDiff("yyyy", [DateOfBirth], Date()) - IIF(Format(Date(), "mmdd") > Format([DateOfBirth], "mmdd"), 1, 0)
