Hi guys.
Having trouble with a messy dlookup giving me an unexpected result
(DLookup("'" & [f] & "'", "RGLN", "[DAYI]=" & "'" & [a] & "'"))
Where f and a are variables
I should be getting a null value based on what is in the table but the result it is returning is equal to the value of variable f rather than looking in the field named by f to tell me what is there for record a. I'm sure i've got the syntax wrong for what I'm trying to achieve and am hoping one of you experts can point out the missing/extra whatever it needs...
Thanks in advance