DLookUp with 2 Tables

D

DS

What is the synatax for using DLookup with 2 Tables. I'm pulling info
from one base on criteria from both tables.
Thanks
DS
 
R

Rick Brandt

DS said:
What is the synatax for using DLookup with 2 Tables. I'm pulling info
from one base on criteria from both tables.
Thanks
DS
Click to expand...

DLookup() can look at exactly the one "domain" that is specified in the second
argument. If you can build a query that outputs data from both tables then you
can use that query as the domain. Otherwise you need two DLookup() calls.
 
D

DS

Rick said:
DLookup() can look at exactly the one "domain" that is specified in the second
argument. If you can build a query that outputs data from both tables then you
can use that query as the domain. Otherwise you need two DLookup() calls.
Click to expand...
Thanks Rick, I was afraid of that. I made a Query and it worked.
Thanks
DS
 

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

dlookup 4
Using Max or DMax in DLookUp criteria? 1
DLookup 2
DLookUp to write to new table 5
Dlookup on form - help please 2
Dlookup in table won't work 2
Access ACCESS DLOOKUP INVALID USE OF NULL 0
Pulling data into a form and making it save 7

Top