IF(OR Statement in Access

[Nabiyah1]

Can anyone tell me if its' possible to use the same type of IF(OR Statement that can be used in Excel, in Access. I'm a little green to all of this, comparatively, and I need a little help.

I want to know if I can say... IIF(OR([fieldname]<[fieldname],[fieldname]<[fieldname),"y","n") but it doesn't work. Am I writing something wrong? Or is this function not available in access. It works fine in excel.

Thanks for your help with this,
Ny

 

[Nabiyah1]

Solution

This can be solved by placing the OR between the arguments, instead of in front, like in Excel. For example:

DysBtwn: IIf([DCallRtrnd]>#3/31/2005# Or [DCallRtrnd]<#1/1/2005# Or [DCallRcvd]<#1/1/2005# Or [DCallRcvd]>3/31/2005#, "DateConflict",
"1stQtr")

I figured this out for myself, but I wanted to post an answer here, just in case someone else needed the answer, and the post didn't receive any other replies.

Hope this is helpful for some of those who may be a little green like me
Have a great week!

Ny

 

[Andrew Fergus]

Good on you for working it out!

There are a few functions in Access that work like operators (i.e. between the arguments instead of at the front). Other examples include 'And' as well as 'Mod' to name just 2. I'm sure there are plenty more...

Andrew