I create the following in the view designer and I getting and error message:

SELECT Orders.o_orderno, Products.p_productname, Orders.o_orddte,;
  Orders.o_ordcomp, Orders.o_qty, Orders.o_unitprice, Orders.o_orderedby,;
  Products.p_warehouseno, Vendors.v_name, Orders.o_checkmark,;
  Orders.o_v_vendorid, Orders.o_p_productid, Orders.o_orderid,;
  Orders.o_w_whsid, Whsupv.whs_name, Orders.o_tmp_amt, Orders.o_tmp_qtyrec,;
  Orders.o_tmp_daterec, SUM(Recdetail.rd_qtyrec);
 FROM ;
     warehouse!orders ;
    INNER JOIN warehouse!products ;
   ON  Orders.o_p_productid = Products.p_productid ;
    LEFT OUTER JOIN warehouse!recdetail ;
   ON  Orders.o_orderid = Recdetail.rd_o_orderid ;
    LEFT OUTER JOIN warehouse!whsupv ;
   ON  Orders.o_w_whsid = Whsupv.whs_id ;
    LEFT OUTER JOIN warehouse!vendors ;
   ON  Orders.o_v_vendorid = Vendors.v_id;
 WHERE  Orders.o_orddte >= ( ?lc_bdate );
   AND  (  Orders.o_orddte <= ( ?lc_edate );
   AND  (  Orders.o_w_whsid BETWEEN ?lc_fwid AND ?lc_twid;
   AND  (  Orders.o_ordcomp == ( "NO" );
   AND  sum(Recdetail.rd_qtyrec) > ?lc_rectot ) ) );
 GROUP BY Orders.o_orderno, Products.p_productname, Orders.o_orddte,;
  Orders.o_ordcomp, Orders.o_qty, Orders.o_unitprice, Orders.o_orderedby,;
  Products.p_warehouseno, Vendors.v_name, Orders.o_checkmark,;
  Orders.o_v_vendorid, Orders.o_p_productid, Orders.o_orderid,;
  Orders.o_w_whsid, Whsupv.whs_name, Orders.o_tmp_amt, Orders.o_tmp_qtyrec,;
  Orders.o_tmp_daterec;
 ORDER BY Orders.o_orddte

the error message is:

File 'sum.prg' does not exist

It seems like my expression in the where clause is not being accepted, is there a way around this or I'm creating the expression wrong? I need to tally the amounts in recdetails and see if they are greater than parameter being passed.

WHERE  Orders.o_orddte >= ( ?lc_bdate );
   AND  (  Orders.o_orddte <= ( ?lc_edate );
   AND  (  Orders.o_w_whsid BETWEEN ?lc_fwid AND ?lc_twid;
   AND  (  Orders.o_ordcomp == ( "NO" );
   AND  sum(Recdetail.rd_qtyrec) > ?lc_rectot ) ) );

thanks in advance

nick