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

"Biederboat" <Biederboat@discussions.microsoft.com> wrote in message
news:ECD3B368-7BE8-4A9F-96BB-5C086A5D76C1@microsoft.com...
>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