K
Keke Lee
I failed to process a DLookup Query. Herewith my sample:
columns in table [#code]: #Sec Code,#QtyOfSum
columns in table
columns in table [#code]: #Sec Code,#QtyOfSum
columns in table
Code:
: Sec Code,QtyOfSum
My work is to return the value of [QtyOfSum] by looking up if [Sec Code]
=[#code].[#Sec code].
My query:
SELECT [#code].[#Sec Code], [#code].[#QtyOfSum],
DLookUp("[QtyOfSum]","[code]","[Sec Code]"="[#code].[#Sec Code]") AS dluTable
FROM [#code];
The above returns no value from "dluTable" column .
Indeed my true work is more complicated than above sample. My DLooKup has to
be a query upon another query indeed, though I failed from above simple
sample (query to table) anyway
Many thanks Keke