Simple Query Not Working

[SimRick]

The parameter query looks like this:

SELECT [Orientation and Med Course].Name, [Orientation and Med Course].[Class Name]
FROM [Orientation and Med Course]
WHERE ((([Orientation and Med Course].[Class Name]) Like [Please Enter A Class Name]));

I can see the results I want when I filter by form, but this query won't return any results. I am using it in a more advanced query so I don't want to save the filter as a query. What am I not seeing?

 

[cmmrfrds]

If you have an exact class name then use = otherwise the "Like" normally needs the wildcard character *.

Like "*classname*"

 

[SimRick]

Thanks... I have an exact class name, they are actually quite simple, like "module #1". I even copied and pasted the name directly from the table to make sure. If I remove the parameter from the query, it shows all results.

 

[cmmrfrds]

The = should work for you.

This is a case where the data is causing the problem with the like clause.

The # is a special mask character.

enter like this module [#]1 if you want to use special characters in the data. The [] tells access that it is data not a mask character.

 

[SimRick]

Right You Are! I just learned a valuable lesson. Thank you very much for your help.