Recent content by wizard607

Thanks alot for your help.

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).]

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).]

Gotit. Thank You very much.

Thank You R. Hicks for your response but I,m getting the error message: circular reference caused by alias.

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?