SQL Question Again - (hit enter and sent first attempt)

SoftSpot · Guest

Trying to create a search string to handle searching within an MSAccess TEXT
field. Having problems when the variable is numeric
Tried: (spaces expanded for clarity)

strWhere = strFieldName & "= ' " & cstr(vVariable) & " ' " - raised an error
when vVariable is numeric

tried testing for numeric value first:
if IsNumeric(vVariable) then
strWhere = strFieldName & "=" & val(vVariable)
else
strWhere = strFieldName & "= ' " & cstr(vVariable) & " ' "
end if

This also didn't work. What's the work around on this?
Thanks in advance for any help offered
Owen Schwer

Guest

Post question of this sort to the following:
microsoft.public.access.queries
microsoft.public.vb.general.discussion
WKidd

"SoftSpot" <SoftSpot@discussions.microsoft.com> wrote in message
news:C786FF24-4AD6-4293-BBBD-C5F58E5DBBA5@microsoft.com...

Tom Dacon · Guest

For numeric values, it's:
strWhere = strFieldName & "=" & cstr(vVariable)
you want it come out something like:
WHERE Price = 12

for string values, you need to enclose the string in single-quotes, so it:
strWhere = strFieldName & "= ' " & vVariable & " ' "
you want it to come something like:
WHERE State = 'Washington'

There are better places than this to post programming questions, especially
something like a question about an SQL query. Microsoft has many newsgroups
that are devoted to programming subtopics. Why on earth would you post this
to a newsgroup that's dedicated to Microsoft MCSD certification instead of
one of those?

Tom Dacon
Dacon Software Consulting

"SoftSpot" <SoftSpot@discussions.microsoft.com> wrote in message
news:C786FF24-4AD6-4293-BBBD-C5F58E5DBBA5@microsoft.com...