I need to return all result records from a swimmer's result database that
are within a date range by year.  The results are achieved on a specific
date stored in a meet database.  For example: all results for all females
when they were in the 11-12 age group.  Some of those girls may now be 13
so you can't go by their birthday alone.  It has to be the date of the meet
- their birthday in years!  (need to subtract the dates and return the
result as a year not in days and allow for leap years, etc.)

Any suggestions would be appreciated.  I assume a subquery would be needed
but can't put it together.

Assuming each record is for the results of a swimmer, you need to insert
another field that would indicate the type of competition (11-12).  This
could be done with an execute (SQL) statement in VB or or an action query
in Access, or manually in Access.  You then would be able to query on a
date range and competition.
Steve Lowther