Creating a null list...

[lonesomejubilee]

Hello,

My boss wants me to make a solution that will tell her who DIDN'T do an activity. Example: Say you have a solution to track training. A user signs in and does presses the "Yes" radio button or whatever at the end. You could easily generate a list of who DID participate, right? But how would you go about providing a list of who DIDN'T participate? Because if the employee never signed in the system, you'd never know. Say you have 50 employees, you could easily find who did the training. Pretend 15 people didn't do it... so you have a total of 35 who did, and you could name each of those 35... but you don't know (without cross checking by hand) the names of the 15 who didn't even log it.... so how could I make it so I would know?

My only idea is to create 50 "dummy" records that are defaulted to "NO" so I could search by the default... as they complete training they'd change that No to Yes... thereby leaving the NO's accounted for.

I would have to create a script, however, that would create each individual "dummy" record per person...

It seems that I am missing something here, and that there has to be a better way.. any ideas?

V

[comment]

Well, one simple way to find those who didn't is to find those that did, then show omitted records.

Possibly, you could also utilize a relationship using the ≠ operator - but you haven't provided enough details about your solution to be certain.