I'm trying to change the below code to incorporate several selnames,167 & 789 both would use the same Query as below. I have tried several suggestions but no luck - any ideas?
Code:
IIf([selName]=167, DLookUp("[Desc]","[OptLQuery]","Index=selOptL"))
Asked
Active
Viewed 124 times
1
-
IIf(OR([selName]=167,[selName]=789),DLookUp("[Desc]","[OptLQuery]","Index=selOptL")) ought to work I think (but can't test) – Harassed Dad Jan 22 '19 at 15:33
-
Thank you for your response I tested but only 167 gets a result. Any ideas? – Shevy Jan 22 '19 at 15:56
-
Is that in VBA or in a Query ? Why don't you use a `JOIN` ? – iDevlop Jan 22 '19 at 15:57
-
IIF([SelName] In (167,789),...? – Harassed Dad Jan 22 '19 at 16:03
-
Hi ive tried the above but its not returning any results for option L re 167 or 789. Option L has different results for both selnames which when dlookup should populate in a description box. – Shevy Jan 23 '19 at 11:25
1 Answers
0
It should be:
IIf([selName]=167 OR [selName]=789, DLookUp("[Desc]","[OptLQuery]","Index=selOptL"))
Santosh
- 12,175
- 4
- 41
- 72
-
Hi ive tried the above but its not returning any results for option L re 167 or 789. Option L has different results for both selnames which when dlookup should populate in a description box. – Shevy Jan 23 '19 at 11:25
-