Comments by Member 10354489 (Top 1 by date)

I've tried the DateDiff function, but I can only return an answer based on two specific date values. I need to return the age in years on all fields based on the date of birth field for each person in the table. The return will be the age they are at a certain date. It's for a sports club to get a list of all who can compete at a specific age level.
I hope this clarifies where I'm coming from.
Thanks.