Help with quotations in DLookup

[kenton.l.sparks@gmail.com]

Table1 has three fields. I’d like to use the following DLookup statement:

DLookup(“[Field1]”,”Tablename”,”[Field2]=Left([Field3],4)&’55’”)

Note that in the criteria, I want Field2 = the first 4 characters of Field 3 + the string value 55.


I’m sure I’ve got the quotation marks wrong. Any help would be appreciated.

Thanks,
Kent

[Rod]

Try:

DLookup(“[Field1]”,”Tablename”,”[Field2] = ' " & Left([Field3],4) & Str(55) & "’”)