Linking a query value to a table

[Biederboat]

In a query I have pulled out a value in a long text string that represents a
characteristic of the part. I want to use that value (they are integers of
1, 2 3 or 5) to go to antoher table (that has the integer field and an
associated description that tells me what 1, 2 or 3 is (e.g. 1 & 2 are
"Boxes"). However, when I run the query, I get very random values. I'll see
a whole bunch of 3's in a row and in the linked description field in my query
I'll see some as boxes and some as something else. Any help here?

Thanks,
Biederboat

 

[John W. Vinson]

In a query I have pulled out a value in a long text string that represents a
characteristic of the part. I want to use that value (they are integers of
1, 2 3 or 5) to go to antoher table (that has the integer field and an
associated description that tells me what 1, 2 or 3 is (e.g. 1 & 2 are
"Boxes"). However, when I run the query, I get very random values. I'll see
a whole bunch of 3's in a row and in the linked description field in my query
I'll see some as boxes and some as something else. Any help here?

Thanks,
Biederboat

Not without knowing a bit more about what you're doing!

What's the structure of the table? How are you "pulling out" the value? Please
post the SQL of your query, any code you're using, and perhaps an example.