Hi Martin

I have just maked som other changes, and now it works fine.

THANKS

>Hi Benn,
>

>* for MS Access
>=SQLEXEC(x,"SELECT [as-rno] as as_rno from table")
>
>* Other ? I don't known.
>=SQLEXEC(x,[SELECT "as-rno" as as_rno from table])
>

>
>MartinJ
>
>>Hi,
>>
>>I have to select a field from a remote table that contains a '-' in the fieldname (as-rno). The SQLEXEC() returns an error on this field.
>>
>>How do I fix this problem ??????
>>
>>Best regards
>>Benn