Thanks!

>>Hi:
>>
>>The following SQL produces the following output. Obviously there's something wrong with the IIF, but how do I guard against division by zero?
>>
>>Thanks,
>>
>>Yossi
>>

>>SELECT SUM(FeedWeight) FeedWeight, ;
>>	SUM(FeedCost) FeedCost, ;
>>	SUM(Feedcost)/iif(SUM(FeedWeight)=0,0.001,SUM(FeedWeight)) FeedCostPerlbFeed ;
>>	FROM prereportcursor ;
>>	INNER JOIN curCoop ;
>>	ON curCoop.CODE = feedmill ;
>>	GROUP BY curCoop.CODE ;
>>	INTO CURSOR ReportCursor
>>
>>
>>FEEDWEIGHT            FEEDCOST    FEEDCOSTPERLBFEED
>>         0.00        0.00000000                 0
>>   3270490.00      245.77180000                 0
>>   4286240.00   398193.47120000                 0
>>