SELECT SKU, COUNT(units),SUM(sales) FROM table GROUP BY SKU ----- Original Message ----- From: "Dick" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 9:22 AM Subject: [RBASE-L] - Report... Duh!
Ever feel like you're just having a mental time-out? Trying to define a report that with pull distinct SKU's from todays sales, along with total of no of units and total of days sales amt by SKU. Have tried various ways & I can't make it work. Know this ain't hard. HELP

