I would try to recreate indexes on the Xcaller table. If it doesn't help, than table itself may got corrupted. Try to browse it and look for strange (binary) characters.

> 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 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)