Group By Date

[BB45]

CR 10
CE 10
SQL 2000

I am grouping by a client name (group#1) and then by a date (group#2) of the four dates for a particular client 3/9/2008, 3/15/2008, 3/23/2008 and 4/6/2008. I only get three groupings 3/9, 3/23, and 4/6. The 3/15 record is included in the 3/9 grouping.

Any ideas why this might be doing this?

Thanks
BB

 

[kskid]

Since 3/9 and 3/15 are in the same week, I suspect that you have a weekly grouping on your dates. Change your grouping to daily.

-lw

 

[BB45]

Thanks.

I knew it was something simple that I was overlooking.