>i have a table that has 2 coulms one is order date and the other is customer id i want to know how many orders a customer did with out cuonting more than one order per day for example if in one day he hs more then one order i want to count only one i did select ord_date,cus_id from my table group by 1,2 and i still get more than one record for a custumer per date
Try
SELECT DISTINCT OrderDate, CustomerID ;
FROM table1 ;
INTO CURSOR crsTemp
SELECT CustomerID, COUNT(*) ;
FROM crsTemp ;
INTO CURSOR crsResult
--sb--