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...