Where do you intend to use it?
Except in queries, the IIf statement should not be used in Access. It has
issues and is hard to read. The main issue is that both the true and false
condition have to be valid before the evaluation is done or you will get an
error. It evaluates both side first, then does the comparison, where a
normak If statment only evaluates the code when it executes.
You will have to get more explicit on what you want. There are no cell
references in Access. Also, there is no WeekNum function in Access, so it is
hard to know what you are after. You have to be comparing memory variables,
form or report control values, or table or query field values.
If you can explain what you want to do, perhaps we can show you how to do it.
