lcCustPrsched='CU02' lcContPrsched='CO03' lcProdserv=INPUTBOX('Enter Product Code','Product Pricing','AGE100') CREATE SQL VIEW vu_Pricing as ; SELECT pricebase.prodserv ; , prsched.baserate ; , SUM(IIF(pricebase.code = ?lcCustPrsched ,pricebase.rate ,0.000) ) rate ; , SUM(ROUND(IIF(pricesched.type=='%' ; , rate*IIF(pricebase.code = ?lcCustPrsched ,pricesched.urgent * 0.01 ,1 ); , rate+IIF(pricebase.code = ?lcCustPrsched ,pricesched.urgent ,0.0)),2)) dprice1 ; , SUM(ROUND(IIF(pricesched.type=='%' ; , rate*IIF(pricebase.code = ?lcCustPrsched ,pricesched.general * 0.01 ,1 ); , rate+IIF(pricebase.code = ?lcCustPrsched ,pricesched.general ,0.0)),2)) dprice2 ; , SUM(ROUND(IIF(pricesched.type=='%' ; , rate*IIF(pricebase.code = ?lcCustPrsched ,pricesched.planned * 0.01 ,1 ); , rate+IIF(pricebase.code = ?lcCustPrsched ,pricesched.planned ,0.0)),2)) dprice3 ; , SUM(ROUND(IIF(pricesched.type=='%' ; , rate*IIF(pricebase.code = ?lcContPrsched ,pricesched.urgent * 0.01 ,1 ); , rate+IIF(pricebase.code = ?lcContPrsched ,pricesched.urgent ,0.0)),2)) cprice1 ; , SUM(ROUND(IIF(pricesched.type=='%' ; , rate*IIF(pricebase.code = ?lcContPrsched ,pricesched.general * 0.01 ,1 ); , rate+IIF(pricebase.code = ?lcContPrsched ,pricesched.general ,0.0)),2)) cprice2 ; , SUM(ROUND(IIF(pricesched.type=='%' ; , rate*IIF(pricebase.code = ?lcCustPrsched ,pricesched.planned * 0.01 ,1 ); , rate+IIF(pricebase.code = ?lcCustPrsched ,pricesched.planned ,0.0)),2)) cprice3 ; FROM prsched ; LEFT JOIN pricebase ON prsched.baserate == pricebase.basecode ; LEFT JOIN pricesched ON prsched.code+pricebase.prodserv == pricesched.prsched+pricesched.prodserv ; WHERE pricebase.prodserv = ?lcProdserv AND prsched.code IN (?lcCustPrsched,?lcContPrsched) GROUP BY pricebase.prodserv USE wots!vu_Pricing BROWSE