Dlookup not working

[geoffcodd]

I have the following formula, which won't work, I have experimented with the syntax with no joy

Unit_Cost: DLookUp("[Unit_Cost]","tblTariff","[Tariff_Name] = " & [Tariff] & " And [Tariff_Date] <= #" & [Month_Pres] & "#")

Tariff_Name & Tariff are TEXT
Tariff_Date & Month_Pres are Date

Any suggestions appreciated
Thanks
Geoff

 

[Mile-O]

Unit_Cost: DLookUp("[Unit_Cost]","tblTariff","[Tariff_Name] = """ & [Tariff] & """ And [Tariff_Date] <= #" & [Month_Pres] & "#")

 

[geoffcodd]

Thanks for the quick reply works like a dream, I am never going to get use to the syntax in access

Thanks
Geoff

 

[Mile-O]

Text in "
Numbers without
Dates with #