I'm brain dead at this point, and I know the answer is probably a simple one, but I've tried everything and I can't get it.
What I've got is a system that tracks the progress of a case. I have a list of "Case Activities".....i.e., Step 1, Step 2, Step 3 and so forth. This table lists the Activity and then an Activity ID. What I'm trying to do is design queries/reports that willl serve as a tickler system. For example, show all cases where Step 1 has been completed but not Step 2, and so forth down the line. Everything I try lists EVERY case in which there is a Step 1, which I don't want.....I want a listing where there is a Step 1 but no Step 2. Any ideas???? Please help; am on a big time deadline!!!! Thanks!
What I've got is a system that tracks the progress of a case. I have a list of "Case Activities".....i.e., Step 1, Step 2, Step 3 and so forth. This table lists the Activity and then an Activity ID. What I'm trying to do is design queries/reports that willl serve as a tickler system. For example, show all cases where Step 1 has been completed but not Step 2, and so forth down the line. Everything I try lists EVERY case in which there is a Step 1, which I don't want.....I want a listing where there is a Step 1 but no Step 2. Any ideas???? Please help; am on a big time deadline!!!! Thanks!