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

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

=?Utf-8?B?U29mdFNwb3Q=?=

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

"SoftSpot" <> wrote in message
news:C786FF24-4AD6-4293-BBBD-...
> 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
>

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" <> wrote in message
news:C786FF24-4AD6-4293-BBBD-...
> 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
>

Tom Dacon