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!
2  1170 
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!
What is the datatype of VarRate
Look at my post on your previous question on this issue.
NeoPa 32,556
Expert Mod 16PB
varRate = Dlookup ("[Symbol]", "Quadriserv_102306", "MarketPrice = 5.05")
?varRate
AA*
This was helpful - can you post the same for the other way around?
...So show results for - varRate = DLookUp("[MarketPrice]", "Quadriserv_102306", "[Symbol]='AA*'")
-
?"=" & varRate & "="
Sign in to post your reply or Sign up for a free account.
Similar topics
by: KLAU |
last post by:
I have a field that retrieves information from an expression in a
query. I have used a DLookup function to get the calculated field
from the query. However, the relationship is 1-to-many so one...
|
by: Norman Fritag |
last post by:
Hi there,
I am wonder why this dlookups return null, despite having a record in the
table with a matching date?
Am I missing something here???
Am i running in some limitations, that I am not...
|
by: MLH |
last post by:
I have tried using DLookUp in this manner...
If DLookUp("","tblClients","='2021234567'") Then
MsgBox "Found it!"
End If
I am wondering if that is a misuse of the DLookUp command?
Type...
|
by: MLH |
last post by:
DLookup("", "tblPreliminaryVINs",
"=Forms!frmVINODO!SerialNum")
is giving me a Type Mismatch error. That's confusing to me
and I don't know how to circumvent it. The field in...
|
by: MLH |
last post by:
The following SQL returns PRECISELY what I want:
SELECT TOP 1 tblCorrespondence.CorrespID,
tblOutboundTypes.OTypDescription, tblCorrespondence.OutDate,
tblCorrespondence.VehicleJobID,...
|
by: ineedahelp |
last post by:
Does anyone know why my DLOOKUP evaluates to NULL for every instance of symbol. In the table, some of the values of MARKETPRICE are blank, some have a number, type double and some of the values are...
|
by: boyleyc |
last post by:
Hi all
the following code works perfectly well. Basically it populates a
series of check boxes on my form, depending on whether dlookup finds an
associated record.
The problem i have is that...
|
by: Denise |
last post by:
Front end is Access 2002, back end is linked Oracle tables.
My users need to describe things in feet and inches and want to use
the standard ' and " abbrevations.
On a testing form I go to a...
|
by: Constantine AI |
last post by:
Hi i am trying to get User input if data does not exist within a DLOOKUP table. I have gotten it to work for one record but not multiple, i have tried to incorporate my code into a loop procedure but...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
