Hello people,
I'm writing a custom function that checks three criteria and assigns a boolean value based on the outcome. At the moment I have nested Select Case statements to check these but I started wondering whether there was a better alternative.
as an example:
criteria 1 as a supplier name
criteria 2 as a product
criteria 3 as a date
if a particular product comes from supplier 1 or 2 then i'd set to true otherwise false.
I thought about putting together a table but there are instances where the flag is set to true only when it's between a specific date range so I wasn't sure how this could be incorporated.
Any ideas for alternatives I may not have thought of?
Thanks
Nick
I'm writing a custom function that checks three criteria and assigns a boolean value based on the outcome. At the moment I have nested Select Case statements to check these but I started wondering whether there was a better alternative.
as an example:
criteria 1 as a supplier name
criteria 2 as a product
criteria 3 as a date
if a particular product comes from supplier 1 or 2 then i'd set to true otherwise false.
I thought about putting together a table but there are instances where the flag is set to true only when it's between a specific date range so I wasn't sure how this could be incorporated.
Any ideas for alternatives I may not have thought of?
Thanks
Nick