DLookup Function

  • Thread starter Thread starter Stryker22150
  • Start date Start date
S

Stryker22150

I have a query where I would like to capture the 2nd character in a
text field. The second part of this would be based on that value to
return the description. I have a lookup table that contains the 2
position and the description of the value I want. I have researched the
DLookup function however I am not sure if this is the right function to
use.

TIA
 
Stryker:
You can make a calculated field that displays the second character in the
textfield with this:
Mid([TextField],2,1)
where you put in the name of your textfield.
It's not clear from your post where the value of TextField is coming from.
Is this on a form or subform, a combobox, or what? Depending on that, you
would need to incorporate the above expression in the WHERE clause of your
query.

HTH
 
Back
Top