Try to use [] for character variables instead of quotes.
>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.
If it's not broken, fix it until it is.
My Blog