You've looked everywhere? Including the Access help?
anyway,
IIF is a function
IIF(expr, truepart, falsepart)
like:
sometxtbox =(somenumber > 1000, "true", "false")
where it tests a variable (somenumber) and returns true or false if value is
greater than 1000.
your function is missing the required true and false parts.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
