Matching help

[Terminus]

Help i need to match two tbls!!!!

What i have is one table with info on contacts Ie

tblContacts
Contact---Interest---InterestName
1 ---3 ---Swimming
1 ---4 ---Football
2 ---4 ---Football

And then another tbl (tblmailshot)with
MailshotID---Interest
1 ---3
1 ---4

This information is created by via a form using list boxes. On the form tblmailshot users select which contacts hey want to find by selecting possible interests, see tblmailshot above.

The problem i have is that i need an SQL statement that will select only users which have been selected by tblmailshot. Because all i can get it to do is select contacts with 'Interest 4' OR 'Interest 3' not AND

Can any1 help?

Ross

 

[Rolliee]

How are you using the data? You might have a main form with a listbox to set the interests and a subform with all the interests.

rollie@bwsys.net