DLOOKUP in Access Query

[kish1983]

Hi,

How to use DLOOKUP in access query

I have 2 table,

table one table has equipment name & table 2 contain equipment name with completion date

I need query to retrieve date from table 2 as per value of code in table 1

I tried to use DLOOKUP to do this, but getting some error

ID	Equipment Name	D/C Join Date
1	W-14018-Vardhaman-H 9405	12-Mrz-15
2	W-14018-Vardhaman-H 9406	13-Mrz-15
3	W-14018-Vardhaman-H 9407	20-Mrz-15
4	W-14018-Vardhaman-H 9407	09-Mrz-15

ID	Equipment Name
14	W-14018-Vardhaman-H 9403
1	W-14018-Vardhaman-H 9404
2	W-14018-Vardhaman-H 9405
3	W-14018-Vardhaman-H 9406
4	W-14018-Vardhaman-H 9407

I am using below expression in query, but cant get the date


Expr1: DLookUp([D/C Join]![D/C Join Date];[D/C Join];[Equipment Name]=[Equipment Name])

pls help to correct this expression

[evander]

You should try using an outer join first. DLOOKUP consumes a lot of system resources. You have to avoid it as much as possible.