Re: Call History script

Dale E. Reed Jr. ( (no email) )
Thu, 04 Jun 1998 23:39:48 -0700

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)