I am baffled by the Case Statement and curious if anyone has this issue.
The case statement goes through each test in order and returns the first result where a test is true.
However, how do you avoid this if there are multiple conditions to be met?
Below is the statement I am having difficulty with, simple delivery date using greater than less than operators with dates.
Qty Ship = Order Qty ; "Bullseye" ;
Qty Ship ≥ Minimum ; "In Spec";
Qty Ship ≤ Minimum ; "Below Min Spec" ;
Qty Ship ≤ Maximum ; "In Spec";
Qty Ship ≥ Maximum ; "Above Max Spec" )
I looked through the forum but can't find anything related to this. It seems like a simple thing to fix but the lightbulb just wont't go on.