how to remove Part Numbers with zeros in front (column with >200,000 records)

Create a query from your lookup table and replace the code
field (assuming that's its name) with a calculation that
returns Val(

Code:

) if is numeric and [code] if not. Then
use the query instead of your lookup table. That should do
it.

David

Top