>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'
Try to use explicit call Do vfpxtab.prg with ..., and make sure that vfpxtab.prg is included in Exe.
Edward Pikman
Independent Consultant