Re: Call History script
Dale E. Reed Jr. ( (no email) )
Thu, 04 Jun 1998 23:39:48 -0700
> 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)