DLookUp with 2 Tables

  • Thread starter Thread starter DS
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

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

Using Max or DMax in DLookUp criteria? 1
dlookup 4
DLookup 2
DLookUp to write to new table 5
Critria Mismatch 2
Access ACCESS DLOOKUP INVALID USE OF NULL 0
DLookup Issue 9
Pulling data into a form and making it save 7

Back
Top