I have a table in MS Access with the fields
AutoNumber Study ID Activity Age Min Age Max 1 A01 Football 3 28 2 A01 Swimming 6 12 3 A01 Cycling 5 14 4 A01 PE Classes 5 16 5 A01 Basketball 13 16 6 A01 Gym Various/Personal Fitness 15 34 7 A01 Football 31 34 8 A02 Triathlon 31 34 9 A02 Football 10 18 10 A02 Golf 33 34
Now I seriously can't believe I can't think of a single way to query this table to get any one who played football
between the ages of 5 and 16
So Basically I would want it to return
AutoNumber Study ID Activity Age Min Age Max 1 A01 Football 3 28 9 A02 Football 10 18
So things that won't work
Age Min >=5 (Obviously its gonna filter out age min 3 coz its looking for everything is 5 or over
Age Min <=5 (It will exclude age min 10 coz that doesn't fit the criteria)
Age Min between 5 and 16 (Nope same problem as the first one 3 doesn't count)
So I need a query that counts Age Min and Max as a range and then checks if 5 or 16 is within that range. I can't think of how I can do this without having to write a function.. unfortunately a function is useless to me as it cannot be used in a Excel Data Connection.
So then.... HOW DO I QUERY THIS? My brain is drain it won't work anymore.