DLookup Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please tell me what is wrong with this:

=DLookUp("[SumOfManual Recall]","[ARLTTLCallbackMosaixQuery]","[Date]=#" &
[Date] & "#")

It is coming up Error on my report. Thanks in advance for any help.
 
What have you checked?

Do you have a query of the name ARLTTLCallbackMosaixQuery that isn't a
parameter query?
Is there a field named Date in the query?
Is the a field/column in your report named Date?
What is the name of the text box? It can't be the name of a field.
Are all the values for Date in the query ARLTTLCallbackMosaixQuery unique?
What happens if you open the debug window (press Ctrl+G) and enter:
?DLookUp("[SumOfManual
Recall]","[ARLTTLCallbackMosaixQuery]","[Date]=#7/1/2004#")
 
I got it. My text box was named the same as my field in the query. I should
have checked before I put this post, but you guys have been so helpful I just
knew someone would help me quickly. I will look closer before I post from
now on. Thank you.

Duane Hookom said:
What have you checked?

Do you have a query of the name ARLTTLCallbackMosaixQuery that isn't a
parameter query?
Is there a field named Date in the query?
Is the a field/column in your report named Date?
What is the name of the text box? It can't be the name of a field.
Are all the values for Date in the query ARLTTLCallbackMosaixQuery unique?
What happens if you open the debug window (press Ctrl+G) and enter:
?DLookUp("[SumOfManual
Recall]","[ARLTTLCallbackMosaixQuery]","[Date]=#7/1/2004#")

--
Duane Hookom
MS Access MVP
--

Brent said:
Can someone please tell me what is wrong with this:

=DLookUp("[SumOfManual Recall]","[ARLTTLCallbackMosaixQuery]","[Date]=#" &
[Date] & "#")

It is coming up Error on my report. Thanks in advance for any help.
Click to expand...
Click to expand...
 
Back
Top