Dlookup Evaluating To Null

Originally Posted by ineedahelp

I have been struggling with the code below and wondering why it continues to return a NULL value.

varRate = DLookup("[MarketPrice]", "Quadriserv_102306", "[symbol] = '" & strSymbol & "'")

MarketPrice is of type Number/Double and Symbol is a text field. I am wondering if the DLOOKUP function can have a Non-text field as the EXPRESSION. When I switch things around....

varRate = Dlookup ("[Symbol]", "Quadriserv_102306", "MarketPrice = 5.05")
?varRate
AA*
It works just fine!!! Can anyone tell me if DLOOKUP can have a double number as the expression? If not, why not? Thank you and pulling my hair out!

Originally Posted by INeedaHelp

varRate = Dlookup ("[Symbol]", "Quadriserv_102306", "MarketPrice = 5.05")
?varRate
AA*