Need help on writing a syntax

baq

(Charles Dingas) #1

I am need help writing a quick syntax for a BAQ I have. I want a calculated field that shows only the supervisor id/name. I know this is a check box in EmpBasic, but am unsure how to write the syntax.

I know case when might work but I am not sure I am entering it correctly.

Thanks,

Charles


(Ken Nash) #2

A case statement? This is pseudo code.

CASE WHEN EmpBasic.Checkbox1 = 1 THEN EmpBasic.Name ELSE “” END


(Charles Dingas) #3

I’ll try it… thanks.