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: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
