>Why don't you post the SQL code you are trying to render to Access?
>
>In VFP, you have more freedom than you should when it comes to ordering different parts of a SQL Statement. Other environments, like Access and SQL Server, are more strict.

I do not think the IIF statement works in Access either.... which i like to use in the denormalized mess of a database i must work with....


I am not sure what you mean by 'post'

I issue an SQLSTRINGCONNECT() command to connect to the .mdb

m.lnHandle = SQLSTRINGCONNECT(m.lcConnectionString)
m.lnResult = SQLEXEC(m.lnHandle,"SELECT blah blah","AccessResult")

I'd just like to know the syntax of the SQL SELECT statement when it is sent to an Access97 .mdb backend.

Thanks...