>Do you want to group by each hour? If so, GROUP BY LEFT(dType, 13).
>
>If you want to group by date only, GROUP BY LEFT(dType,10)At this point I want to GROUP BY each 10 seconds, i.e. 1/6th of a minute.
I'm sure that at some point I will want to consolidate larger chunks of data. Thanks for the help.
Randy Bosma
VFP - Because life is too short to code in something else...