Points1: IIf([points] Between 3 And 5,2,0),IIf([points] Between 6 And 9,4,0)
I've used nested IIF before, but not with "between".
TIA!
Points1: IIf([points] Between 3 And 5,2,0),IIf([points] Between 6 And 9,4,0)
I've used nested IIF before, but not with "between".
TIA!
What does the ,2,0 mean??? What are you trying to do --in plain English?
Syntax details and example of IIF
The IIf expressions are not nested. What error message?
Try:
Points1: IIf([points] Between 3 And 5, 2, IIf([points] Between 6 And 9, 4, 0))
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Orange, If the members points are between 3 and 5, then assign them 2, or 0, if they are between 6 and 9 then assign them 4 or zero. I should probably only have one zero at the end now that I think of it. I ended up doing in the long way, but I don't like it. I'll try your suggestion Ridders. And June, they are nested, they work fine separately.
Thanks all, you rock!
The original posted expression is not nested. It is two separate IIf and should error.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
This worked, thanks Ridders! Points1: IIf([points] Between 3 And 5,2,IIf([points] Between 6 And 9,4,0))