calc not working

[faaslave]

I have this calc

Case ( 



Sup Crew = "1" or "8" or "15" or "22" or "29" or "36";

 "Sat/Sun";

Sup Crew = "2" or "9" or "16" or "23" or "30" or "37";

 "Sun/Mon";

Sup Crew = "3" or "10" or "17" or "24" or "31" or "38" ;

 "Mon/Tue";

Sup Crew = "4" or "11" or "18" or "25" or "32" or "39";

 "Tue/Wed";

Sup Crew = "5" or "12" or "19" or "26" or "33" or "40";

 "Wed/Thu";

Sup Crew = "6" or "13" or "20" or "27" or "34" or "41";

 "Thu/Fri";

Sup Crew = "7" or "14" or "21" or "28" or "35" or "42";

 "Fri/Sat";

 "unknown"



)

No matter what number is in the field (Sup Crew), the result comes out "Sat/Sun"

I don't get it, it should work.

Thanks Dave

[Raybaudi]

Hi

you can't write a multi-condition so:

Sup Crew = "1" or "8" or "15" or "22" or "29" or "36"

but eventually so:

Sup Crew = "1" or Sup Crew = "8" or Sup Crew = "15" or Sup Crew = "22" or Sup Crew = "29" or Sup Crew = "36"

This type of calc can be solved by a simple Choose (), so try this:

Choose (

Mod (Sup Crew ; 7 );

"Fri/Sat";

"Sat/Sun";

"Sun/Mon";

"Mon/Tue";

"Tue/Wed";

"Wed/Thu";

"Thu/Fri"

)

[faaslave]

Works Great, and I see why mine didn't work now.

That is quite a calc.

So the mod does some kind of division, with 7 being the divisor?

Very tricky, but excellent for what I need.

Thanks a bunch,

Dave