View Single Post
  #2 (permalink)  
Old December 8th, 2005, 05:47 AM
leehambly leehambly is offline
Friend of Wrox
 
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

the iif function works like this...

iif([Logic to be determined],[case if true],[case if false])

so... what your initial statement says is:

if [Forms]![frmOutflow]![fsubOutItem]![cboCategory1Select]=1 then return the value ">0"

... are you sure this is correct? What does ">0" actually mean and how is it supposed to return that as a single value?
Reply With Quote