What fields should be in the CallHistory Table I'm using the enhanced db
file from the ftp site but I'm not sure it has all the required fields.
*********** REPLY SEPARATOR ***********
On 6/4/98, at 11:39 PM, Dale E. Reed Jr. wrote:
>jmercer wrote:
>>
>> Running a test in MSQuery it gives me the error Didn't expect
'CallHistory'
>> after the SELECT column list.
>
>Actually, I had the syntax backwards. Assuming you have a CallHistory
>table with the correct columns, this should do it:
>
>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