Looking up a value in a query

B

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking a query value to a table 1
Filtering values in a query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
using dlookup in a query 2
bitwise operator in SQL 3
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
dlookup in Query 10

Top