Thank Jason...
My SQL had (written by DWC)... 'ORDER BY DAYOFWEEK(User_JoinDate) ASC'
Changed it to your suggestion and its put them in the correct order!...
Also the date function works great! Thought I do have another quick question...
If these are the dates in the records that are pulled into the chart... you'll notice that the 4th December is missing...
Dec 2,2010 = 9 Users
Dec 3,2010 = 3 Users
Dec 5,2010 = 3 Users
Dec 6,2010 = 5 Users
Dec 7,2010 = 2 Users
Dec 8,2010 = 1 Users
because no one signed up on that day. I want the chart to be able to show the last 7 days of activity... So I'd like the 4th to appear in the chart... but show that there were zero records on that day OR if no one signed up all week, it would just show a flat line of along the 0 axis. How can I do this??