Query not working with Data Access page

  • Thread starter Thread starter R. Weston
  • Start date Start date
R

R. Weston

i have the following query:

PARAMETERS [SpecToSearchBy] Text ( 255 );
SELECT *
FROM sec1
WHERE (((sec1.spec) Like "*" & [SpecToSearchBy] & "*"));

which works fine when i try it in access. The parameter
is requested and i enter something like "prf" and it
returns all the data. Now when i try it through the data
access page, it gets no results.

I tried:

PARAMETERS [numbertofind] Long;
SELECT *
FROM test
WHERE [test].[test] = [numbertofind];

with some numerical data through the data access page and
that worked.

Is there something that has to be done different with
using LIKE and text?
 
Back
Top