DLookup in a query

  • Thread starter Thread starter Cheese_whiz
  • Start date Start date
C

Cheese_whiz

Hi,

Setup:

Query A columns: table1pk, table1Field2, column3 (calculated: ??)

Query B columns: table2pk, column2 (calculated from data in table2)

Question:

Can I use DLookup in QueryA:column3 to lookup table2pk in query B where
queryB.column2 = queryA.table1Field2

??

Wow, hope that makes sense!

Thanks,
CW
 

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

Transforming empty fields into "0" in a query 3
Complex Queries 1
Dlookup in query - any pointers? 1
SQL to query columns that are in seconds since 1/1/1970 6
SQL and MS-Access 1
Dlookup in query 1
Union Issue 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top