General information
Category:
Coding, syntax & commands
Title:
Querying against Access database
Environment versions
Database:
Jet/Access Engine
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only