You're welcome

>Excellent, thanks Jaime.
>
>>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.