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:
>> Running a test in MSQuery it gives me the error Didn't expect
>> 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)
>Where CalLDate >= '5/1/98'
> and CallDate < '6/1/98'
> and AcctStatusType = 2
>Group By UserName
>Order By Username
>Dale E. Reed Jr. (firstname.lastname@example.org)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
Internet - email@example.com