I used the "Mid" function in a query to extract a single integer from a long
part number field. I want to use that field (the single integer field) to
return a value in another table. I used Dlookup without success: Expr1:
DLookUp("[Description]","[Unit type]","[Type] = [Type]")

Can someone tell me what I'm doing wrong or which function I should be using?

Thanks,
Biederboat