Nick, Ed:

None of the suggestions worked. The current status. Crosstab runs find from an APP and runs fine from an EXE within VFP, but gives the error "File not found" when the EXE is run alone.

This code was generated using the Query designer including the crosstab syntax. Any other ideas.

Code:

SELECT dtoc(diallog.rundate) + " " + diallog.dialtime as shift,;
Diallog.dial_loc, COUNT(Diallog.dial_type);
FROM diallog;
WHERE Diallog.dial_type = thetype and;
Diallog.rundate >= statbeg and;
Diallog.rundate <= statend;
GROUP BY 1, Diallog.dial_loc;
ORDER BY 1, Diallog.dial_loc;
INTO CURSOR SYS(2015)
DO (_GENXTAB) WITH 'dcounts1'