Hi
I'm hoping someone can help a frustrated newbie with an Access sql conundrum.
I have a memo field in one table which contains a string of comma delimited numbers, which are the autonumber IDs of people who have met a previous search criteria. I want to do a query that finds other fields in the table in which their ID is the Primary Key.
i.e if the memo field in table 1 contains the string 1,2,4 and table 2 contains:
RoleID, emailadd
1,a@email.com
2,b@email.com
3,c@email.com
4,d@email.com
I want my search results to be:
a@email.com
b@email.com
d@email.com
but not c@email.com because 3 isn't in the comma delimited memo field.
Is this possible?
Thanks in advance for any help!
TimP
I'm hoping someone can help a frustrated newbie with an Access sql conundrum.
I have a memo field in one table which contains a string of comma delimited numbers, which are the autonumber IDs of people who have met a previous search criteria. I want to do a query that finds other fields in the table in which their ID is the Primary Key.
i.e if the memo field in table 1 contains the string 1,2,4 and table 2 contains:
RoleID, emailadd
1,a@email.com
2,b@email.com
3,c@email.com
4,d@email.com
I want my search results to be:
a@email.com
b@email.com
d@email.com
but not c@email.com because 3 isn't in the comma delimited memo field.
Is this possible?
Thanks in advance for any help!
TimP