Logical Operator

:Table

Orders

OrderID	Payment Type	Ship State/Province
1	Check	IL
2	Check	NY
3	Credit Card	NY
4	Credit CardCredit	IL
5	Check	IL

:Query

Qr_Orders

OrderID	Payment Type	Ship State/Province	expr1
1	Check	IL	-1
2	Check	NY	-1
3	Credit Card	NY	0
4	Credit Card	IL	0
5	Check	IL	-1

expr1: ([orders]![payment type]="check" And [orders]![ship state/province]="ny") Or ([orders]![ship

(" state/province]="il" And Not [orders]![payment type]="credit card

طبق کوئری بالا و عبارت Expr1  رکورد یک :  چون در اینجا بهم ریختگی هنگام نمابش وجود دارد جای نقطه پرانتز بگذارید 

(pay="Check" (True ) And State="ny" (False) Or ..... State="il" (True)  And Not Pay="Credit Card (True

.True And False.   Or .True And True.

False Or True 

True =-1

طبق کوئری بالا و عبارت Expr1  رکورد سه :

(pay="Check" (False ) And State="ny" (True) Or ..... State="il" (False)  And Not Pay="Credit Card (False

.False And True. Or .False And False.

False Or False 

Flase=0

طبق کوئری بالا و عبارت Expr1  رکورد چهار :

(pay="Check" (False ) And State="ny" (False) Or ..... State="il" (True)  And Not Pay="Credit Card (False

.False And False. Or .True And False.

False Or False 

Flase=0

:Query

Qr_Orders

OrderID	Payment Type	Ship State/Province	expr1
1	Check	IL	-1
2	Check	NY	-1
4	Credit CardCredit	IL	-1
5	Check	IL	-1

مثال دوم  :

:Query

Copy Of Qr_Orders

OrderID	Payment Type	Ship State/Province	expr1
1	Check	IL	-1
2	Check	NY	-1
3	Credit Card	NY	0
4	Credit Card	IL	0
5	Check	IL	-1
6	Check	NX	0
7	Check	NZ	0
8	Check	IL	-1

expr1: ([orders]![payment type]="check") And ([orders]![ship state/province]="ny" Or [orders]![ship

(" state/province]="il

طبق Expr1 در گرید بالا : 

رکورد یک

 (Pay="Check" (True) .... And  State="ny" (False) Or State="il" (True 

.True And .False Or True 

True And True

True=-1

رکورد دو

 (Pay="Check" (True) .... And  State="ny" (True) Or State="il" (False 

.True And .True Or False 

True And True

True=-1

رکورد 6 

 (Pay="Check" (True) .... And  State="ny" (False) Or State="il" (False 

.True And .False Or False 

True And False

False=0

:Query

Copy Of Qr_Orders

OrderID	Payment Type	Ship State/Province	expr1
1	Check	IL	0
2	Check	NY	-1
3	Credit Card	NY	-1
4	Credit Card	IL	0
5	Check	IL	0
6	Check	NX	0
7	Check	NZ	0
8	Check	IL	0

expr1: ([orders]![payment type]="check" Or [orders]![payment type]="credit card") And [orders]![ship

("state/province]="ny

رکورد اول 

pay="check" True Or Pay="Credit Card" False.... And State="ny" False

True Or False. And False.

True And False

False=0

رکورد دوم 

pay="check" True Or Pay="Credit Card" False.... And State="ny" True

True Or False. And True.

True And True

True=-1

Copy Of Qr_Orders

OrderID	Payment Type	Ship State/Province	expr1
2	Check	NY	-1
3	Credit Card	NY	-1