Here it is. Need to set a variable in a report in 6.5++ as follows. Can't get it right. This is based on a Master table having a pon and custnub2 column. The Cust_Discount table having a CustNub2 column. Finally the Charges table having a CustNub2 and ChargeType columns. The report driving table is Master This will not work Discount = Discount_Amt in Cust_Discount Where CustNub2 = CustNub2 and PON in (Sel PON from Charges where ChargeType = 31 or ChargeType = 32) The below works for getting the discount amount on the report but in cases where there is no data for ChargeType 31 or 32 in the charges table we do not want this discount to be included on the report. Any sugestions on a diferent approach. Discount = Discount_Amt in Cust_Discount Where CustNub2 = CustNub2 Stephen Breen CDI Services, Inc. 3610 Deahl Ct. P.O. Box 3838 - 46619 South Bend, IN 46628 800-492-8135 Ext 207 Fax: 574-247-4631 www.911roadrepair.com <http://www.911roadrepair.com/> [email protected]
