I am having trouble with a simple query using the DLookUp function. I am using the DLookUp function to look up values in a field in a "temp" table (holds a single record of data that changes). The DLookUp function works fine when the "temp" table field I am performing the lookup has a single name. I also have instances when the field will be populated with multiple names with an "Or" between the names. For example, the query works fine when there is just one name..."Name1"...but if I have the field in the "temp" table showing text of ("Name1" Or "Name2") then the result doesn't work. I think the DLookUp result is only seeing this entire string as pure text and not separating the text as "Or" statements. Is there a way to force the query to see this as "Or" statements vice pure text?
I am trying to get away from using more complicated logic of separating the string into smaller pieces and using the "Or" statement in between multiple names.
Thank you!