Linking a query value to a table

  • Thread starter Thread starter Biederboat
  • Start date Start date
B

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
 
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
Click to expand...

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.
 
Back
Top