I'm doing a Union with 2 identical tables and I'm trying to order be some additional fields that I'm adding. However if I put a variable as the field number to order by I get an error.
Could someone please help.

lnFields = fcount("DirectAddress")

Select DirectAddress.*, .T. as Direct, nSSC as Code;
from DirectAddress;
union select ResidueAddress.*, .F., Residue;
from ResidueAddress;
order by Evaluate(lnFields) desc;
into Cursor AddressOrder nofilter

Thanks in anticipation.