>>Hello All;
>>
>> I have a simple select statement on a table that just continues to error out on me(Fatal Error: Exception Code C0000005), but the SQL Statement is soooo simple, it just doesnt make any sense at all! Here is the SQL Statement:
>>
>>SELECT ;
>> slsv, ;
>> Notes, ;
>> AcctNum, ;
>> Buyer,;
>> Call1AGt, ;
>> Call2Agt, ;
>> Call3Agt, ;
>> Call4Agt, ;
>> Call5Agt, ;
>> Status, ;
>> LastCall, ;
>> Phone1, ;
>> Phone2 ;
>> FROM Xcaller ;
>> WHERE LastCall Between(CallDate,(date()-nDaysback), Date()) ;
>> INTO TABLE C:\TEMP\CALLTMP1
>>
>>Nothing crazy in there, pretty straight forward, right?? so what am I missing Guys?(and Gals ofcourse)
>
>WHERE clause is invalid. it must be:
>
>WHERE Between(LastCall ,(date()-nDaysback), Date())
>
>
>or something else but not: WHERE LastCall Between(CallDate,(date()-nDaysback), Date()) ;
>
>What type is LastCall field?
The LastCall Field is a Date field... it is a valid statement.