Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access 2000 SQL - Join 2 tables using BETWEEN

Status
Not open for further replies.

KMITCH

MIS
May 1, 2000
42
US
I would like to be able to join two tables using something
like 'Table1.Age BETWEEN Table2.MinAge and Table2.MaxAge'.
Is this possible in access?

Thanks,
Keith [sig][/sig]
 
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]
 
Thanks Terry! That was exactly what I needed.

Keith [sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top