If_Worksheet Function not available in Access 2002

[Jim]

We recently update to Access 2002. The If_worksheet
function is not available and we can not seem to load it
from the ProPlus Package. Any thoughts?

 

[Lynn Trapp]

Access uses IIF() -- immediate IF -- in the place of Excel's IF() Function.

 

[Jim]

I know that. But the function is not available and we can
not load for the cd. All of my forms and queries use it.

 

[Lynn Trapp]

When you say "the function is not available" when and where are you
attempting to use it. Do you have an example of the syntax you are using?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm