C
CAM
Hello,
I have a two part question 1.) I have a table called "Parts#" that has a
particular field called "ItemNumber" now this table field size is 30 and as
a text field. My problem is I am trying to query a particular item number
(i.e. 555A), but I get no result. If I type Like "555A*" I get 555A,
555AF, 555AT, or 555V. I just want to get 555A only. How do I get just
555A? 2.) I am trying to join using the Parts# table using the field
"ItemNumber" to join to another table called "Summary" with a field to join
called "Item", which is a text field and a field size 16. Now "Item" field
has 555A and I have the same problem from question #1 (above) can't get
555A, just 555AF, 555AT, or 555V.I am trying to join the two tables I cannot
get any results. Can someone help me. Thank you n advance.
Cheers
I have a two part question 1.) I have a table called "Parts#" that has a
particular field called "ItemNumber" now this table field size is 30 and as
a text field. My problem is I am trying to query a particular item number
(i.e. 555A), but I get no result. If I type Like "555A*" I get 555A,
555AF, 555AT, or 555V. I just want to get 555A only. How do I get just
555A? 2.) I am trying to join using the Parts# table using the field
"ItemNumber" to join to another table called "Summary" with a field to join
called "Item", which is a text field and a field size 16. Now "Item" field
has 555A and I have the same problem from question #1 (above) can't get
555A, just 555AF, 555AT, or 555V.I am trying to join the two tables I cannot
get any results. Can someone help me. Thank you n advance.
Cheers