Thanks,
That worked fine... it's frustrating as a newcomer to VFP that there are so many different ways to do the SAME thing.
>>I have a report that has a field that is a currency sum printed in a GROUP footer. Based on info in another field, sometimes this field is blank and the customer would prefer it to NOT be there instead of $0.00.
>>
>>I was able to add a IIF to the expression for the field as follows...
>>
>> IIF(codetype="Administrative",emp.time,"")
>>
>>emp.time is the amount field. The properties are set for SUM and currency for the format. When this field comes to print - if the codetype="Administrative", I get the appropriate summed amount... if it is not "Administrative", I get ******. I tired changing the "" to null, 0, and also setting the IF BLANK REMOVE LINE to yes. None of these seem to work.
>>
>>Suggestions?
>
>
>
>Why not simply Set the
Print Condition>
>DoubleClick to edit the field!
>Click on Print Condition.
>
>Fill in:
>
codetype="Administrative">
>This will appear If and only If the condition statement is true!
>
>^_~
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!