VBA SQL Terms

  • Thread starter Thread starter James
  • Start date Start date
J

James

Is IN a valid vba SQL term?

Like:

Select * From table Where field IN a, b, c;
 
Strictly speaking, there is no such thing as 'VBA SQL'. It is the database
engine (JET if you are using an MDB) that interprets the SQL command. To
VBA, it's just another string.

That said, IN is a valid (JET) SQL term, you're just missing the parentheses
around the value list and the quotes around the string values ...

SELECT * FROM TableName WHERE FieldName IN ('a', 'b', 'c')

See 'IN Operator' in the help files for more information.
 
thanks.
Brendan said:
Strictly speaking, there is no such thing as 'VBA SQL'. It is the database
engine (JET if you are using an MDB) that interprets the SQL command. To
VBA, it's just another string.

That said, IN is a valid (JET) SQL term, you're just missing the parentheses
around the value list and the quotes around the string values ...

SELECT * FROM TableName WHERE FieldName IN ('a', 'b', 'c')

See 'IN Operator' in the help files for more information.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subquery Correllated In Select Clause - Is this possible? 3
Example Of VBA SQL Statement 0
SQLServer 2012 Replication (using C#) 1
Run 2nd query using results from 1st query 0
What are the steps to fix damaged MDF files in SQL Server? 0
Memo Search 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Book Suggestions for VBA Development and Sample Databases 2

Back
Top