The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I have a table in my Access DB that contains a field with lists of comma-delimited usergroup IDs. How can I select only those records in which the usergroup ID of the current user does not appear in the list of usergroup IDs in the database?
Something like this doesn't work:
SELECT * FROM TABLE WHERE " & m_usergroup & " NOT IN exclude_usergroups"
m_usergroup in this case could be "4", and a particular record could have an exclude_usergroups field value of "1,2,5,6".
Something like this doesn't work:
SELECT * FROM TABLE WHERE " & m_usergroup & " NOT IN exclude_usergroups"
m_usergroup in this case could be "4", and a particular record could have an exclude_usergroups field value of "1,2,5,6".
Posted
What is the table that has the usergroups to be exclused?
Posted
you need to do
SELECT * FROM TABLE WHERE '" & m_usergroup & "' NOT IN exclude_usergroups"
SELECT * FROM TABLE WHERE '" & m_usergroup & "' NOT IN exclude_usergroups"
Posted
So, late response, but better late than never, right?
I tried your suggestion Huw, but I get this error:
I tried your suggestion Huw, but I get this error:
Code:
Microsoft JET Database Engine error '80040e14'
In operator without () in query expression 'sectionid=103 AND '0' NOT IN usergroup'.
Posted
try
SELECT * FROM TABLE WHERE '" & m_usergroup & "' NOT IN (exclude_usergroups)"
SELECT * FROM TABLE WHERE '" & m_usergroup & "' NOT IN (exclude_usergroups)"