T
T Smith
I would like to create a query (without using code) to use part of a field
and to find matching records in a second table. Example. "189X" is field
data. Want the query to match only the numeric portion of the field "189" to
"189" in the second table. Also if anybody knows how to account for zeros it
would be helpful. For example it the field data is "004X" would like the
query to convert it to "4" and find matches in the second table.
Any help would be greatly appreciated.
and to find matching records in a second table. Example. "189X" is field
data. Want the query to match only the numeric portion of the field "189" to
"189" in the second table. Also if anybody knows how to account for zeros it
would be helpful. For example it the field data is "004X" would like the
query to convert it to "4" and find matches in the second table.
Any help would be greatly appreciated.