Error with SQL statement.

[tbiceps]

When I run the following SQL statement in the immediate window. I get the following error:
The SELECT statement includes a reserved word or an argument name that is mispelled or missing, or the punctuation is incorrect.

DoCmd.RunSQL " Select TESTTABLE t, TBL_FieldID f, TBL_Index i WHERE t.[Report ID]=i.[Report ID] AND f.[Field ID] = i.[Field ID]

 

[Golom]

You're missing a FROM clause.

 

[tbiceps]

How about this statement. I get a run-time error '2342'
A RunSQL action requires an argument consisting of an SQL statement.

DoCmd.RunSQL "SELECT t.[Report ID], f.[Full Field Name] FROM TESTTABLE t, TBL_FieldID f, TBL_Index i WHERE t.[Report ID]=i.[Report ID] AND f.[Field ID] = i.[Field ID]"

 

[JerryKlmns]

tbiceps

Create your queries in design view, switch to SQL view and grab that. It 's ready for use and error free.......

 

[Golom]

The SQL is OK but RunSQL is designed to process Action or Data Definition queries.

This "Select" query is not one of those.

 

[dhookom]

RunSQL expects an action query. Your query is a select query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tbiceps]

Thanks Golom and JerryKlmns, as usual, I try to overthink the problem.

 

[tbiceps]

Is there a way to test a select query in vba or is design view/SQL view the way to go.

 

[Golom]

You can of course use VBA and open a recordset but the Query designer is probably the mechanism of choice for testing SQL statements.

 

[tbiceps]

Thank you Golom!