eliminate last character

[wizard607]

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?

 

[R. Hicks]

Add two expressions in your query that removes the last character of each entry. Then compare the results of these two expressions.

ExpressionName: Left([YourFieldName], Len([YourFieldName]) - 1)

HTH
RDH

 

[wizard607]

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

 

[R. Hicks]

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.

HTH
RDH

 

[wizard607]

Gotit. Thank You very much.

 

[wizard607]

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