Hi Folks
I am trying to use a query field as criteria for a dlookup expression within the same query but am having trouble with it!
What I have is:
StockNo: DLookUp("StockNumber","tblStock","[StockItem]= " & [StockItem])
Where StockItem is a string.
Would appreciate some assistance as this produces an error in this format.
Many thanks
I am trying to use a query field as criteria for a dlookup expression within the same query but am having trouble with it!
What I have is:
StockNo: DLookUp("StockNumber","tblStock","[StockItem]= " & [StockItem])
Where StockItem is a string.
Would appreciate some assistance as this produces an error in this format.
Many thanks