I'm not sure your method isn't working, but try changing changing the "to date" part to "< '2012-02-08' " and see what you get. HTH, Arthur
- strange select/join/group by with rollup issue.... Andy Wallace
- Re: strange select/join/group by with rollup issue.... Arthur Fuller