IIf AND statement in Access

[John P]

Most of my tables have lookup tables to calculate values, but I am in the need of an IF/AND statement and do not have the Access knowledge to draft one. In Excel (substituing my field names for Excel cells) it would look like IF(AND(TranType=PX, Market<>NAT,Derived Type=PA),1,0)

How would I write this in Access? Any input is appreciated. Thanks

 

[Joe4]

Try this:

MyValue: IIf(([TranType]="PX") And ([Market]<>"NAT") And ([Derived Type]="PA"),1,0)

 

[John P]

It worked. Thanks ray:

 

[benuva]

Bunu Access'te nasıl yazarım?

= IF (VE (G5 <> ""; I5 = ""); G5; IF (VE (G5 = ""; I5 <> ""); I5; IF (VE (G5 <> ""; I5 <> ""); I5 ve "-" & G5)))

 

[Micron]

benuva has asked the same question here, and received answers, though not solved
http://www.accessforums.net/showthread.php?t=73869&p=409885#post409885

 

[Joe4]

benuva has asked the same question here, and received answers, though not solved
http://www.accessforums.net/showthre...885#post409885

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.