Query Criteria

[Nancy T]

I have a crosstab query that has "Referring" as the row heading, "Rendering" as the column heading and "Total" as the Value. The query works great except there are times when the "Referring" and "Rendering" data are the same person. The information is correct but I do not want to show those in my results. I only want to show the data that has a "Referring" person with different "Rendering" people.

Can I set the criteria somehow so when "Rendering" and "Referring" are the same nothing shows up?

Any ideas are appreciated!

Thanks.

 

[Philem]

Hullo. Not sure this will work, but in the criteria for "Rendering" you could try "<>Referring" without quotes, of course. That way, only those records were Rendering was not equal to Referring would show.

HTH

P

 

[Nancy T]

I tried it but it didn't work.