>>There is no #DEFINE. There are only those two fields in the analysis table.
>>localcrime1 has nnval (n), crimetype(c), crimedate(d), crimehour(n) and shapename(c) for fields
>>I'll remove the & from the names, try it and report back. But, other crimetypes with the & in the name work fine.
>
>Don't know if it will help, but you might also try

>"B"+CHR(38)+"E Garage"
>"B"+CHR(38)+"E Home"

>
>etc.


It's a big job, but I think I'll replace the '&' with 'and' and see if it solves the problem. I'll let you know what happens after I'm done and tested.