query syntax

  • Thread starter Thread starter Josh
  • Start date Start date
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.
 
" WHERE (n.TableID=2) And (n.PhoneNumber = '" &
Me.phone & "')"

Exagerated for clarity:

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