I've inherited an Access database used to assign topics to individuals. The table we pull the relationship from is formatted thus:
ID 100
RegID 999
TopicID 5
ID 101
RegID 909
TopicID 3
ID 102
RegID 999
TopicID 3
ID 103
RegID 909
TopicID 2
There will be several records for each RegID. My problem is identifying those that DID NOT choose a particular Topic ID. Say 2 for example.
A simple query gives me a list of all records that are not TopicID = 2. But I need to know the RegID records that did not choose TopicID = 2 at all.
ID 100
RegID 999
TopicID 5
ID 101
RegID 909
TopicID 3
ID 102
RegID 999
TopicID 3
ID 103
RegID 909
TopicID 2
There will be several records for each RegID. My problem is identifying those that DID NOT choose a particular Topic ID. Say 2 for example.
A simple query gives me a list of all records that are not TopicID = 2. But I need to know the RegID records that did not choose TopicID = 2 at all.