I am trying to find all records in a table that contain a specific user id from another table. I have roughly 900 entries in the table. So I have a query with both tables.
Table1
Identity
Table2
ReceiverUserIDs
The ReceiverUserIDs field can contain a single user, or multiple users comma separated such as the below:
aaa1111 OR aaa1111,bbb2222,ccc3333
I have:
Field - ReceiverUserIDs
Table - Table2
Total - Where
Criteria - Like [Table1].[Identity]
This will only produce the entries where it finds a matching userid that is not in a comma separated list. So if I am looking for aaa1111 in the below, the results would include both row 1 and 3 instead of just row 1.
<tbody>
</tbody>
Does this make sense? If so, can anyone assist? Thanks in advance!
Table1
Identity
Table2
ReceiverUserIDs
The ReceiverUserIDs field can contain a single user, or multiple users comma separated such as the below:
aaa1111 OR aaa1111,bbb2222,ccc3333
I have:
Field - ReceiverUserIDs
Table - Table2
Total - Where
Criteria - Like [Table1].[Identity]
This will only produce the entries where it finds a matching userid that is not in a comma separated list. So if I am looking for aaa1111 in the below, the results would include both row 1 and 3 instead of just row 1.
1 | aaa1111 |
2 | bbb2222 |
3 | ccc3333,ddd4444,aaa1111 |
<tbody>
</tbody>
Does this make sense? If so, can anyone assist? Thanks in advance!
Last edited: