troubleshooting Question

IIf statement not showing correctly

Avatar of leezac
leezac asked on
Microsoft Access
4 Comments1 Solution272 ViewsLast Modified:
This should be relatively simple..  

If Tran Code = "BUY" or "RBUY then Rule 2 Purch else Rule 2 sales.

or can it be done this way to use "or"?

Expr: IIf([tran code]="BUY" Or "RBUY","Rule 2 Purch","Rule 2 Sales")

Thanks in advance.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros