Hi all,

I'm having a problem querying from an Access table. When the table was setup by another organization, they have the fields such as "testing for a field" is the field name...

I get a connection no problem, I can query other fields from the table, but even on OTHER fields that only have a single space, and qualifying them in the query as ...

select "Some FIeld" as MyVFPFld from "Table 1"

works through a SQLEXEC() call

However, if

select "Some Other Field" as MyFld from "Table 1" -- WORKS

Strange, but the failure will ONLY FAIL if the field name as " TO " as part of it.. ie:

select "AMT TO REFUND" as MyField from "Table 1" -- FAILS

Any ideas???

Thanks