IT depends...

if you're looking for something to split out the values into a list for a more permanent solution, there are a number of scripts on this site to...

CirquedeSQLeil (10/29/2009)

---

you guys lost me in the posts - i show 8914 for Gianlucas last - and this is...

Bob Hovious 24601 (10/29/2009)

---

We're all really pleased you're still alive and online, Roy... and still really pleased about Jack's little girl.

Now if we can only get...

Lynn Pettis (10/28/2009)

---

Roy Ernest (10/28/2009)

---

I got into an accident yesterday. A four car pile up. Thankfully no one got hurt bad. My whole body is sore. Hit my chest badly...

Jack Corbett (10/25/2009)

---

Thanks to all for comments on my daughter's accident. She is definitely fine. Now we have to rein her in so she doesn't over do it...

Based on the query you've supplied, I see no reason for the query to exclude rows that contain NULL values. This would only be the case is you were...

rs, have a look at the first link in my signature. It will help you with formatting your data so that it is readily consumable by the folks here....

Garadin (10/21/2009)

---

It looked to me like it would have to rescan the table for each row in the table for that WHERE clause. I may have misread the execution...

I don't know if that's the best book or not, it's the only one I've paged through. There were some issues with the sample databases that a lot of...

Yeah I probably would still use a matrix, although it could prove to be somewhat hard to handle since once you click on a year and the months would pop...

As per your message to me it seems like you have gotten your counting by the month to work, and now you'd like to aggregate by year then month and...

Well I finally found time to get back to this... I rewired the query and it performs quite well against my real data. Like I said earlier this is...

Any chance you could post a screen shot or perhaps your rdl? Can you be a bit more specific about what did not work for you? Did it...

I'll let you know when I get back into the office tomorrow, but from the preliminary testing I did this afternoon it seems to work fairly well. It's a...

in your query instead of bringing back the entire EnteredOnDate use the month() and year() functions to get you what you need either in addition to the date or instead...