Heya Neal- You'll want to do something like...
SELECT datepart(mm, EnteredDate) as month, count(*) as monthly_count FROM table GROUP BY datepart(mm, EnteredDate) ...to get your counts. This assumes that you don't care about yearly spans or that there will be limiting date range. Hope that helps! On Mon, 5 Jan 2004 12:45:56 -0600 , "Bailey, Neal" wrote: Hey guys, � I need a little direction... � I am trying to count orders placed for each month. I have an "EnteredDate" field and all I am trying to do is display/count how many orders were placed for each particular month. For some reason I cannot get this to work. I am using SQL and MX 6.1. � Can someone show me a snippet of code to start with... � Once I get the values, I want to cfchart it. This I can do... but I always have problem with dates and SQL. � � Also since it's obvious I suck at SQL, is there some type of program that can help me write SQL statements. I usually can figure it out but my biggest problem is remembering how to format everything (I waste so much on this). It would be great if there was something like Dreamweaver where it has a drop down list of options to choose from as you start to type. Well I guess I will stick with my 1200 page Sams book. � Thanks, Neal Bailey Internet Marketing Manager UGA-Association Field Services E-mail: [EMAIL PROTECTED] ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
