Re: Reports showing online time.

Dale E. Reed Jr. ( (no email) )
Tue, 01 Apr 1997 02:16:19 -0800

J Dyer wrote:
> Hi,
> Does anyone have a report that can show total time online (in mins) per calender month by account.
> Or a clue as to how to create it with SQL

Just off the top of my head:

Select Username, TheMonth=DatePart(Month, CallDate),