Works for me too once I set the variable to a legal fieldname.
_2007 vs 2007
Thanks

:)

>>SQL SELECT allows for creation of new field names using AS clause, as in
>>
>>select fieldname as newfieldname
>>
>>This works easily when the newfieldname is know when the code is written, but how can we cause the newfieldname to be a variable as in
>>
>>newfieldname = "newname"
>>select fieldname into &newfieldname
>>
>>All my attempts at macro substitution or other techniques have failed.
>>Is my objective possible?
>>
>>Thanks for any help.
>>
>>- Don
>
>This works for me:
>

>newFldName = [NewFieldName]
>SELECT FieldName AS &newFldName FROM ... INTO ...
>