I have a table that contains part# field
1235.prt.1
1235.prt.2
I want to run a duplicate query. How can I eliminate the last character so that I get an exact match?
Is it possible that you named the expressions the same as the field name? The names of the expressions each must be different from each other and not the same as the field names.
After reviewing my results I realized that some of the records contain more than 1 character after the "." Is it possible to eliminate everything after the last "." The records contain more then 1 "."
[This message has been edited by wizard607 (edited 09-21-2001).]