Greetings,
What is the best way to combine and display the following logic in a crosstab report?
Online: if Section Number = 65; 65A; S165; S265
Hybrid: if Section Number = 75; 75A; S175; S175A
Day: if start time < 5:00pm
Night: if start time =>5:00pm
Other: no start time
I have the following formulas and would like to know if I can somehow combine these and/or find a better way to accomplish the above.
Hybrid = [Section Number] InList (“65”; "65A”; "S165”; "S265")
Online = [Section Number] InList( "75" ; "75A" ; "S175" ; "S175A")
Time =If FormatDate( [Start Time] ;"HHmm") >= "1700" Then "Night"
ElseIf( IsNull( [Start Time]) ) Then "Other" Else "Day"
TIA,
OCM
What is the best way to combine and display the following logic in a crosstab report?
Online: if Section Number = 65; 65A; S165; S265
Hybrid: if Section Number = 75; 75A; S175; S175A
Day: if start time < 5:00pm
Night: if start time =>5:00pm
Other: no start time
I have the following formulas and would like to know if I can somehow combine these and/or find a better way to accomplish the above.
Hybrid = [Section Number] InList (“65”; "65A”; "S165”; "S265")
Online = [Section Number] InList( "75" ; "75A" ; "S175" ; "S175A")
Time =If FormatDate( [Start Time] ;"HHmm") >= "1700" Then "Night"
ElseIf( IsNull( [Start Time]) ) Then "Other" Else "Day"
TIA,
OCM