Anakardian
Registered User.
- Local time
- Today, 12:04
- Joined
- Mar 14, 2010
- Messages
- 173
Does anyone know why access insists on throwing a syntax error when I enter the following in query:
Performance: (IIf([tbl].[Number]>0,0,100))?
After rooting around I ended up doing this by mistake:
Performance: (IIf([tbl].[Number]>0 ,0 ,100))
Then it works however it is still being displayed as:
Performance: (IIf([tbl].[Number]>0,0,100))
Are there any other areas where this strange behaviour can be encountered?
Performance: (IIf([tbl].[Number]>0,0,100))?
After rooting around I ended up doing this by mistake:
Performance: (IIf([tbl].[Number]>0 ,0 ,100))
Then it works however it is still being displayed as:
Performance: (IIf([tbl].[Number]>0,0,100))
Are there any other areas where this strange behaviour can be encountered?