Parameter Not Working

I have a field in my query that pulls from a table. The table is linked to an
ODBC database. I am running a parameter for the first three letters of a
profile. The problem is that the doesn't work for all scenarios that I put
in. The information is in the table but it will not come up in the query
through the parameter. I tried to enter the input the three letters that
won't work directly into the query criteria field and the information still
will not come up. I have even tried making a new query for just that field
and again it doesn't work for all the information I try. Please help.

JS wrote:
I have a field in my query that pulls from a table. The table is
linked to an ODBC database. I am running a parameter for the first
three letters of a profile. The problem is that the doesn't work for
all scenarios that I put in. The information is in the table but it
will not come up in the query through the parameter. I tried to enter
the input the three letters that won't work directly into the query
criteria field and the information still will not come up. I have
even tried making a new query for just that field and again it
doesn't work for all the information I try. Please help.
tap-tap ... something must be wrong with my crystal ball :-)
You're going to need to help me here ...
Switch your query to SQL View (use the View menu, or the toolbar button,
or the right-click context menu) and copy/paste the sql statement into
your reply to this message.

You should also show examples of data where the entered criteria (show
us what you entered) return what is expected, and examples where the
criteria entered fail to return the data.

What is the ODBC database? Type and version please?
Also, what is the datatype of the field you are attempting to filter?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.