Try this. Create a new query in design view. Go to SQL view and paste the following code in.
SELECT table1.Age
FROM table1, table2
WHERE table1.Age between table2.MinAge and table2.MaxAge;
Hope it helps...
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.