DLookUp with Wildcard

[Hudas]

Hi Everyone...

I have to search the Filename field and return the value on HelpDeskNamefield on the Table1. The problem is the data on the Filename field contains only a portion of the value that I am searching. For example... I have 'majdatlate' that I need to search but the data on the Filename field only shows 'majda'. Another example... I have 'kjaooaq' that I need to search but the data on the Filename field only shows 'kjao'. Is this still even possible to use DLOOKUP here? Can someone please show me or give me an Idea please.

Thank you
Hudas

 

[JHB]

Use the function InStr.

DLookup("FieldNameToBeRetured", "TableNameToBeSearchIn", "InStr(1,'Text', [FieldNameWhichHasTheTextPart])"))

 

[Hudas]

Thank you JHB it works this is what i did..

strHelpDeskName = DLookup("HelpDeskName", "t_job", "InStr(1,'" & strFilename & "',[Filename])")

 

[JHB]

You're welcome - luck with your project.