syntax for Dlookup

[Lanason]

can anyone see whats wrong with this syntax

=DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & [Report]![rptComplaintCustCAT3]![FAR Number])

this is entered in a report to get round the problem of the memo field being truncated.

:banghead:

 

[isladogs]

can anyone see whats wrong with this syntax

=DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & [Report]![rptComplaintCustCAT3]![FAR Number])

this is entered in a report to get round the problem of the memo field being truncated.

:banghead:

Is this being done in the report?
If so, replace Report! with Me.

If its not in the report, then it won't work.
You'll need to use a variable to store the value or a function to calculate it

 

[Lanason]

I tried

=DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & me.[rptComplaintCustCAT3]![FAR Number])
and
=DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & me.[FAR Number])

neither worked

it changed =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & [me].[FAR Number]) and then asked to enter the parameter

thoughts??

 

[Lanason]

I found it

=DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & [FAR Number])

needs to be

=DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = '" & [FAR Number] & "'")

SOLVED

 

[Minty]

Ah - the old "Numbers actually a bit of Text" conundrum

 

[isladogs]

So your FAR number is in fact a text string!

 

[Lanason]

Yes - it is prefixed with "FAR"

don't worry I fell for it as well !!!!

 

[Gasman]

Yes - it is prefixed with "FAR"

don't worry I fell for it as well !!!!

Prehaps it should be prefixed with "NOT"

 

[isladogs]

Am I being dense? Should it be obvious what FAR means?

 

[Minty]

Duhh

It's Devonish for txt

Obvs!

 

[Mark_]

Gasman, makes sense for those familiar with a "Southern Drawl"...