May be a stupid question but i have a small DB built in Access, and one of my fields "Work Place" has TWO "Contacts" associated to it each owning a different "Contact Type".

What i would like to do is to view all the "Work Places" and their "Contacts" "Contact Types", but

instead of showing both "Contacts" and their "Types" which are at the same "Work Place", I would like to say that if both "Contacts" and their "Types" are at a particular "Work Place" then still show all of the "Work Places" but Choose one particular "Type" over another, and show one only.

somebody help, its driving me nuts,

Ive tried: "type1" OR "type2" in the criteria field but this just displays both..

Any help would be appreciated.