• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

simple query question

I know this is wrong but could you help please?


("select description from parts where PCID like form.id.text")

Craig
0
csindorf
Asked:
csindorf
1 Solution
 
wsh2Commented:
strSQL = _
   "SELECT [Description] " & _
   "  FROM Parts " & _
   " WHERE [PCID] LIKE '" & form.id.text & "'"

Enclose from.id.text in single quotes.. <smile>.
0
 
PaulHewsCommented:
Concatinate to make a string
"Select description from parts where PCID like " & form.id.text
0
 
csindorfAuthor Commented:
Bingo
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now