Caroline
Try

lnFields = allt(str(fcount("DirectAddress")))

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

HTH
Jaime

>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.