Hi all, I was hoping that I could get some help with this query. TABLE: Items FIELDS: ProductDescription, ItemPrice, ItemDate I want to group first by the week day using the WeekDay function, Sum the item price for each Weekday and order next by the sum of the item price for each weekday in DESC order. I've tried several ways, but keep getting errors that say I'm using illegal group by functions, etc. Any suggestions? Lee Jenkins --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php