I have an If statement in a custom function in Access that doesn't work.
If Project In ("a","d","f","g","x") Then True
Can't I use the IN keyword or do I have to say,
If Product = "a" or Product = "b" or ...
If my list was > 10 items, should I put those items in a table and use DLOOKUP?
If Project In ("a","d","f","g","x") Then True
Can't I use the IN keyword or do I have to say,
If Product = "a" or Product = "b" or ...
If my list was > 10 items, should I put those items in a table and use DLOOKUP?