Help

mugman17

Registered User.
Local time
Today, 16:07
Joined
Nov 17, 2000
Messages
110
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.
 
mugman,

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

Wayne
 

Users who are viewing this thread

Back
Top Bottom