I cannot get this to work.
=DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [PriceType] =" & [PriceLookup] And "[Month]=#" & [Month] & "#")
Is there something wrong with the syntax. It just seems to give me the same result all the time.
Thanks.
=DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [PriceType] =" & [PriceLookup] And "[Month]=#" & [Month] & "#")
Is there something wrong with the syntax. It just seems to give me the same result all the time.
Thanks.