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.