>>This is my code: >>Select ,sum(AMOUNT) as myamount …… >>My question is: I want myamount to be DATA TYPED as CURRENCY 8.4… any ideas? > >SELECT NTOM(SUM(amount)) as myamount... ---------- Hi Trey....thanks
Robert Keith Independent Developer San Antonio, Texas E-mail address: rebelrob1@yahoo.com