And statements

[ahajee]

I have 3 fields below. in my query, i want to see all the records not including MTG1 'and' O. i understand how to use 'and' statements for a particular field but how do you use 'and' statements for 2 different fields.

Loan # Doc Type O/C
1 CMTE
1 MTG1 C
1 MTG1 O
2 MTG1 C
2 CMTE
6 MTG1 O
6 MTG1 C
10
13 MTG1 O
20 CMTE
21 MTG1 C

 

[Joe4]

WELCOME TO THE BOARD!

Using the Query Builder in Access, simply enter your conditions in the Criteria line under each field. If you put your conditions on the same row, they will be treated as "AND". If you put them on different rows, they will be treated as "OR".

 

[Norie]

In the doc field criteria put <>"MTG1" and in the Type field in the same row put <>"O".

Generally in the query criteria:

same row - AND same

column - OR