*********** REPLY SEPARATOR ***********
On 6/5/98, at 11:37 AM, Dale E. Reed Jr. wrote:
>Your CallHistory table should have three fields:
>
>Username (text)
>CallDate (date/time)
>Mins (number, long)
>
>You could put others in if you wanted more information.
>
>> >Insert Into CallHistory
>> >Select Username, CallDate='5/1/98', Mins=Sum(AcctSessionTime/60+1)
>> >From Calls
>> >Where CalLDate >= '5/1/98'
>> > and CallDate < '6/1/98'
>> > and AcctStatusType = 2
>> >Group By UserName
>> >Order By Username
>
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
Jerry Mercer
Ultra-Vision
Internet - jmercer@ultravision.net