Solved Dlookup - wrong result / error

[ggooss]

Hello All,

I have an issue with using Dlookup in a query, it is giving the wrong result back. If someone could help please?

Reference Table (all the fields are Short Text):

The Dlookup:
Val1: DLookUp("Value128","tblCode128A"," ' 128A=" & [Expr1] & " ' ")

The result (wrong):

In the table, the value for Letter A is 33, and the Dlookup returns 16, which is the first value of column [Value128]

What am I missing please?

Thanks a lot
Greg

 

[June7]

Apostrophe is in wrong position in frontof 128A. Field name begins with number (best to avoid that) so enclose field in [ ]. Don't put spaces around apostrophes.

Val1: DLookUp("Value128","tblCode128A","[128A]='" & [Expr1] & "'")

What is Expr1?

What table is query pulling records from?

Why use DLookup? Do these tables have relationship?

 

[ggooss]

Awesome,
This worked:
Val1: DLookUp("Value128","tblCode128A","[128A]='" & [Expr1] & "'")

Thanks a lot June7