Are there any AND() or OR() functions in access? Basically I'm looking to create a value in an if statement, I'm looking for it to return true if either of the following are true:
- Value A = 2
- Value A = 1 and Value B = 2
This is a bit simplified from the actual problem, but a question none the less I'd like solved. I've tried entering said data in an IIF statement as if it were an excel function, but no luck
PS, is there a command list with explanations in Access??? I've searched through the help file and no luck, I think this is a bit of an important thing to leave out.
-Brandon
- Value A = 2
- Value A = 1 and Value B = 2
This is a bit simplified from the actual problem, but a question none the less I'd like solved. I've tried entering said data in an IIF statement as if it were an excel function, but no luck
PS, is there a command list with explanations in Access??? I've searched through the help file and no luck, I think this is a bit of an important thing to leave out.
-Brandon