I have a parts table
1234.prt.1
1234.prt.2
1234.prt.12
I want to run a duplicate query but first I have to eliminate the characters after the last "."
any help would be appreciated
[This message has been edited by wizard607 (edited 09-21-2001).]
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?
