where criteria looking at multiple fields

[camg12]

I'm having a hard time thinking this through. Below is an example of the data. I want to only include those records were

IIf([TYPE]='E',[LOC]='T') and IIf([TYPE]='C',[LOC]='S')
or to just exclude the records (where Type = E And Loc = S)

but I don't know how to write it and include it in my criteria. Any help would be appreciated.

 

[John Big Booty]

Check this link for the correct syntax for Iif And

 

[vbaInet]

... or to just exclude the records (where Type = E And Loc = S)

Perhaps:

            [Type] field    |    [Loc] field
==============================================
Criteria:       <> 'E'               <> 'S'