Average of emails sent a day

[jlg5454]

Hello,

I need to calculate on average how many emails my reps send a day. We have a database that captures (inputted by rep) the date and a separte time stamp along with the reps ID login. The time stamp is recorded as text in the field. Ex(73515 or 121436). What could be the easiest way to approach this that I'm not aware of?

Thanks

 

[longhair]

jlg5454,
wouldn't it be easier if you also had a field for the date?
regards,
longhair

 

[KenWright]

Easy enough to dump into Excel and throw a Pivot table at it I would have thought?

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[longhair]

jlg5454,
sorry - missed that you have a date field. KenWright has a good suggestion.
What type of db is it? I would think you could write a simple query - based on the date (and other parameters - say rep or subject etc) add them up and store in an array based upon the number of elements in the array divide for your average.
i'm not sure i understand the need for the time field in your post.
regards,
longhair