Looking up a value in a query

[Biederboat]

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

 

[Jeff Boyce]

Another approach might be to create two queries. The first one returns your
single-digit value. The second one is based on the first one and joins to
your other table.

Regards

Jeff Boyce
Microsoft Office/Access MVP