text - code problem - query not returning full results

[Chris]

Hello,

I am using access 2007 at the moment.

There is a table in the database I run several queries on, but one of them
doesn't seem to return the correct results.
It has 5 columns. A contains a table autonumber, a person's personal ID
(which can appear several times), a code, a code date belongong to the code
and a code value belonging to the code as well.
Every code in the table begins with the numbers 44. So for example if I run
a query from which I want all the data that has 44P in the code than I type
"44P" in the code criteria field and my result will be all the personal IDs
with all the code dates and code values that equal 44P for the code.
However, the same kind of query where the code is 44g1, and the criteria is
set as "44g1" does not return all the results I have.

Does anyone have any ideas or suggestion as to why I do not get along with
this particular query? I would really appreciate your help. Thank you very
much

 

[Tom van Stiphout]

On Thu, 23 Jul 2009 03:57:01 -0700, Chris

You may have some additional spaces or other funny characters. Try
this criteria instead:
like '*44g1*'

-Tom.
Microsoft Access MVP

 

[Chris]

Tom,

Thank you very much for your reply. You have highlighted something missing
in my patchy access knowledge. So I am looking into the difference between "
and ', but this has definitely solved this problem and probably the other,
similar, question of mine too. Thanks a lot again!!!

Chris