query syntax

J

Josh

I need help with pass-through query syntax on the
following where clause:

" WHERE (n.TableID=2)" And "(n.PhoneNumber = '"" &
Me.phone & ""')"

My double and single quotes are not correct on the second
half of the expression. The phone number is text (varchar).
Thanks is advance.
 
D

Douglas J. Steele

" WHERE (n.TableID=2) And (n.PhoneNumber = '" &
Me.phone & "')"

Exagerated for clarity:

" WHERE (n.TableID=2) And (n.PhoneNumber = ' " &
Me.phone & " ' ) "
 

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

Help with DCOUNT syntax 2
Query SQL Syntax 2
Calling Parameterized Query Using SQL Syntax 3
ConcatRelated: How do I add an additional field? 0
syntax error in query 2
SQL syntax error with vba 3
query syntax error 1
iif function syntax problem 5

Top