I am trying to get results through a query that will enable me to show the results of a column, where some of the records set to a value in another column does not appear.
column 1 - hospital
column 2 - Drs.
If Dr_1 from column 2, is a member of hospital_1 and hospital_2 from hospitals, hide Dr_1, else show him with the other Drs, and all the hospitals.
The qry runs to make a new table.
Neep some help to write an easy sql statement.



[This message has been edited by hsuresh (edited 10-23-2001).]

You can't do what you want with the query but you can do it in the report. Use the hide duplicates property.