Simple query

[morlan]

Morning all, happy Chinese New Year,

Here's my table:

tblMain


A - B
1 - 0
1 - 1
0 - 1
0 - 0

If there is a 1 in either field I want a query to return 1 in field C.
If a 0 in both fields then it should return 0. Is this simple enough?

qryMain


A - B - C
1 - 0 - 1
1 - 1 - 1
0 - 1 - 1
0 - 0 - 0

 

[Mile-O]

NewField: IIf([Field1]=1,1,IIf([Field2]=1,0))

 

[dcx693]

Gung hay fat choy dudes.

How about an alternative?
MyField: IIf([Field1] Or [Field2],1,0)

 

[Mile-O]

lol, I've always approached that like the OR in Excel - totally different. No wonder it's never worked for me....

 

[dcx693]

I like the Or (and And) function in Excel better. It's more concise.

 

[morlan]

Great, thanks guys. Got this sorted with your help.