First, your profile says you use 2007 but the attached is a later version. You should update your profile since some of us don't download later versions because we sometimes can't work with them. If one problem, after the point where you provided the attachment, is still that you don't understand why you get too many records if you provide an Outcome as criteria when using the query Analysis Query ActionJHB then the explanation would be this:
- you have fields a (date), b and c and you ask for records where
- Date is some value and b is some value OR
date is same value and c is some value OR
date is same value and b is some value AND c is some value
and so on. All or many of these OR conditions are being met. In other words, you get what you ask for (Referral) plus you get outcomes for any other outcomes that satisfy the other criteria.
So now I'm confused because when I open the report in question (I think) your attached version seems to work. If you want me to check it out further, provide step by step instructions as to what I need to do to replicate the problem. Clarify what the problem currently is and what the outcome should be.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.