Liveware Publishing Support Forum

Within the IIF function, how do I specify to skip a record if it doesn^t fulfill the condition?____Let^s say I^m looking at records with a quantity field (Q). I only want to view those records with a quantity of less than 100.____I^ve tried writing (unsuccessfully) these ways:____IIF(Q<100,Q,blank) ...