a query with a combination criteria

[ariansman]

We have the following table.

ID   studentname    lectureplace       lecturesubject
1         jack           A             Biology    
2         steve          A             politics    
3         jack           B             math    
4         steve          A             math    
5         jack           B             politics    
6         joe            A             politics    
.          .             .                .
.          .             .                .
154       Jane           B            Geography

We need a query to implement two criteria to extract the following records:
1- Show lectureplace A AND politics lecturesubject
2- Show only those with lectureplace B regardless of the subject
In case the query is run we will have the following result:

ID   studentname    lectureplace       lecturesubject
2         steve          A             politics    
3         jack           B             math    
5         jack           B             politics    
6         joe            A             politics    
.          .             .                .
.          .             .                .
154       Jane           B            Geography

Thank you very much

 

[gblack]

Within your query...

On the criteria line for Field: lectureplace
Put: "A" on the line underneath (i.e. the "or:" line) Put: "B"

In the criteria line for the field: lecturesubject Put: "politics"

This should give you A + politics or B + any subject