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
 
Top