>I have a datetime field in my VFP3 table. I want to COUNT all the records for my datetime field between a specified TIME regardless of the date.
>
>I want to find the busy times of the day for my system and use all the data in my system, not just one days worth of info.
>
>Can this be done with a SQL command?
>
>Thanks,
>
>Jerry Tovar
How 'bout
SELECT datetime, ttoc(datetime),count(*) from tablename group by 2 into cursor busytime
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
