I am using a query designer that created this query just for lookup:

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 );
 ORDER BY Orders.o_orddte

When I go to save I get and error saying "SQL: GROUP BY clause is missing or invalid"

I'm not sure which one to group by. I do have a sum field (Recdetail.rd_qtyrec) in my select fields. I tried a group on Recdetail.rd_qtyrec but it still gave me that error. Any clues as to what I'm doing wrong?

thanks
Nick