DLookup 2nd character in a text string

[DubCap01]

Hi all,

I have a table TblGuests, with two text fields, GuestID (number) and PIN (text). Field PIN can only contain 4 characters.
I need a DLookup something like this:



=DLookup ("only the 2nd character of the string in PIN", "TblGuests","GuestID = Forms!FrmConfirm!GuestID")

Is this possible, or should I be looking at another way of retrieving it?

thanks in anticipation
Pete

[orange]

Perhaps Mid (PINField,2,1)

see this for syntax and examples

[John_G]

Try:

=DLookup ("mid(PIN,2,1)", "TblGuests","GuestID = Forms!FrmConfirm!GuestID")

[Missinglinq]

I'd think you'd run Mid() against the DLookup:

=Mid(DLookup("PIN", "TblGuests","GuestID = " & Forms!FrmConfirm!GuestID), 2,1)

Linq ;0)>

[DubCap01]

Thanks MissingLinq, all fixed

[Missinglinq]

Glad you got it working!

Linq ;0)>