Dlookup syntax with 3 variables as criteria (1 Viewer)

[Drand]

Hi Folks

Could someone please assist me with this. I cannot get the correct syntax!

MyLatestDate is Date
Supplier is String
StockItem = String

I am trying to:

Dlookup ("StockNumber","TblStock",Supplier = Supplier and StockItem = StockItem and DateAdded = MyLatestDate)

Many thanks

 

[arnelgp]

Dlookup ("StockNumber","TblStock","Supplier ='" &  Supplier & "' and StockItem = '" & StockItem & "' and DateAdded =#" & Format(MyLatestDate, "mm\/dd\/yyyy") & "#")

 

[Drand]

Thanks again.
works a treat!

 

[arnelgp]

just remember the syntax for the Criteria part:

if the criteria is string, enclosed in single quote,
if date, add hash (#) before and after.
use & to concatenate each criteria.

 

[namliam]

Why use a DLookup at all, what is your goal?

D functions have their time and place, but 75% of the time there is a (much) better way of doing things.