Well to be five or over on 12/2/10 there dob would have to be equal to or
greater than that date 5 years ago.
So use criteria to filter the data
<= DateAdd("yyyy",-5,#12/2/10#)
Your date is ambiguous. Is it supposed to be December 2, 2010 or February
12, 2010? If you are using a date literal such as 12/2/10 then you must
express that date in the form month day year or year month day (yyyy-mm-dd).
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County