Dlookup format

[PhoneTech2]

I have several tables. The key field that links these tables is called device_id.

When I use dlookup in a report I run into a problem.

If I want to display an extension number from table devices I enter a dlookup statement that looks like this:

=dlookup("extension","devices","device_id=device_id)

It does not work.

If I first create a text box: Text1=device_id and then do a lookup:

=dlookup("extension","devices","device_id=text1&quot

It works. What am I doing wrong?

 

[jebry]

Hi!

Try it like this:

=dlookup("extension","devices","device_id=" & text1)

hth
Jeff Bridgham
bridgham@purdue.edu

 

[PhoneTech2]

I am sorry, I must not have made myself clear.

=dlookup("extension","devices","device_id=text1&quot works.

I just do not want that extra step of creating text1

I want to use the same field name device_id in the criteria.

 

[raddster]

PhoneTech2,

Why not prefix the device_id with the table it comes from?

ie,

=dlookup("extension","devices","tbl1!device_id=tbl2!device_id)

Hope that helps

 

[PhoneTech2]

It works! Thank you very much. I know there had to be a way, and I just could not figure it out. (All I know about Access is from doing it, and looking at others.) This little trick goes into my refernce book. Thanks again.