Help

[mugman17]

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.

 

[WayneRyan]

mugman,

=DLookUp("[Price]", _
         "tblPrice",
         "[LocationID] = " & [Location] & " And [PriceType] = " & [PriceLookup] & " And [Month] = #" & [Month] & "#")

Wayne