Excluding Records Conditionally

[John_Hardwick_(Guest)]

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) -doesn^t recognize "blank"__IIF(Q<100,Q) -no operator__IIF(Q<100,Q,) -no operator__IIF (Q<100,Q,0) -puts zero, doesn^t skip the record__IIF(Q<100,blanknum()) -puts a blank, doesn^t skip the record____And, while I^m asking, I^d like to know the syntax (if different) for skipping records based on character and date conditions.

[kfleming]

Typically you would use a query to exclude certain records from a report.____Kathleen__R&R Support

[apettinotti_(Guest)]

i didn^t test your exact scenario, but i exclude lines from printing all the time with calculated fields similar to what you^re asking. i suggest you try something like this:____iif(Q>100,.t.,.f.)____and then make the line(s) that you don^t want to print logical to print only on True.