Whst is wrong with this DLookUP function???

[calucho]

hi;
I create a report and I try to use the DlookUp function;
I have a table (Values_T) [ID], [Accepted], [Reject], [VL100], [Vl600], [E-Date] in my reports I have field txtCalc I try to brinf the value of [VL100] to my report and make some calculations, and it is the function

=DLookUp("[VL100]","Value_t”, “[E-Date] = & #04/06/2012#")

but I got a #Error in the field what is in my report, What is wrong n with this function

Thank you for your help.

Calucho

 

[pbaldy]

Since you've hard-coded the date, you don't want the ampersand in there. Double check the table name, as you've spelled it 2 different ways in your post.

 

[calucho]

hi;
sorry I type wrong the table name in the Dlookup it is

=DLookUp("[VL100]","Values_T”, “[E-Date] = & #04/06/2012#")
I did Like this
=DLookUp("[VL100]","Values_T”, “[E-Date] = #04/06/2012#") an got the same result #ERROR in the field in my report.

Thank you

Calucho

 

[pbaldy]

That looks okay offhand. Can you pot the db here?

 

[Pat Hartman]

Make sure the Name of the control is not the name of any field in the form's RecordSource.

 

[Taruz]

hi;
I create a report and I try to use the DlookUp function;
I have a table (Values_T) [ID], [Accepted], [Reject], [VL100], [Vl600], [E-Date] in my reports I have field txtCalc I try to brinf the value of [VL100] to my report and make some calculations, and it is the function

=DLookUp("[VL100]","Value_t”, “[E-Date] = & #04/06/2012#")

but I got a #Error in the field what is in my report, What is wrong n with this function

Thank you for your help.

Calucho

Hi Calucho..

this way try..:

=DLookUp("[VL100]","Value_t", "[E-Date] = #04/06/2012# ")

or this way try..:

=DLookUp("[VL100]","Value_t", "cdbl([E-Date]) = cdbl(#04/06/2012#)")



...

 

[calucho]

Hi Taruz,
Thank you for you help the second option work perfect for my Dlookup. and it is running very nice in my report.

Thank you very much for your help.

Calucho

 

[calucho]

Hola:
I have a table with this value PartID, Supp, Ftlot, Qty, UB-Date, Flag
It is my question is How I can Highlight the hold record when the condition is true
IIF flag = “G”, Highlight the record in my report or there are an option in the conditional formatting in the format to do this for me.
Thank you for your help.