dlookup with a contains criteria?

[noretoc]

Hi there,


Can a Dlookup command search for part of a field rather than the whole thing. EX.
Dlookup is RecipientX = DLookup("RecipientID", "MasterFeedData", "[Logins]=" & Me!JID)

Logins field contains CITIGRTS,CITIGRPS,GTORTTRO
jID input contains CITIGRPS

Currently dlookup looks for an exact match between Logins and JID. I want to change the Dlookup to look for partial matches in the Logins field if possible.

Thank for any assistance.

[June7]

Is Logins field a true multi-value field or just a single text string with comma separators?

If just a text string, try:

"Logins LIKE '*" & Me!JID & "*'"

or

"InStr([Logins],'" & Me!JID & "'>0"

[noretoc]

That did it. I don't know SQL well, and though that the criteria was supposed to be formatted like an SQL statement. I didn't realize that a normal VB comparison would work. Thank you very much, this also helps with cratfting these in the future!!

[June7]

The WHERE CONDITION argument does follow SQL syntax, note the apostrophe delimiters. Date values would use #.