Syntax error (Missing operator) in excel vba

Question

I am getting the error 'Syntax error (missing operator) in query expression:

'tblFICL.Product = Muni/Money Market AND tblFICL.Broker_Code = WELLS'

The full vba query is below. I am guessing this has something to do with my variables prdct and bkr. What syntax am I missing in this query?

'Set and Excecute SQL Command'
strSQL = "SELECT tblFICL.Email " _
    & " FROM tblFICL " _
    & " WHERE tblFICL.Product = " & prdct & " AND tblFICL.Broker_Code = " & bkr & ""

Been looking at this all day, any help would be greatly appriciated.

Jaycal · Accepted Answer · 2013-07-24 19:42:00Z

4

You may need apostrophes before and after your values. Try code below

strSQL = "SELECT tblFICL.Email " _
    & " FROM tblFICL " _
    & " WHERE tblFICL.Product = '" & prdct & "' AND tblFICL.Broker_Code = '" & bkr & "'"

answered Jul 24, 2013 at 19:42

Jaycal

2,0871 gold badge13 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

loha86 Over a year ago

This works! Thank you! Now I will be able to sleep tonight.

Jon Crowell Over a year ago

@loha86 -- you can also say thank-you by accepting the answer. Click the checkmark at the top left.

Collectives™ on Stack Overflow

Syntax error (Missing operator) in excel vba

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related