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

[David Manero]

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

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

David