Dlookup in query?

naobao

Registered User.
Local time
Today, 00:08
Joined
Feb 13, 2014
Messages
99
..........................................
*Table A*
Item Code
JP Code
Qty per case
..........................................
*Table B*
Item No
Lot No
Qty
..........................................
Use Table B to make a query,
I also want to show Table A field "Qty per case",
base on Item No<>Item Code,
if I use two table in query, I can't input new record,
is it use "Dlookup" to show this field "Qty per case"?
Hope somone can help to give me a sample,
Thank very much!!
 
DONT use Dlookup in a query. The QUERY is the dlookup. Join the lookup table to your data table to get the lookup value.
 
I join two table and solve my problem!!

Thanks!!
 

Users who are viewing this thread

Back
Top Bottom