I need a case statement to append information into a single text field.
I have 5 Trigger (check box) fields. I want to create a case statement that will add text to the field if it is checked. I don’t know if i should create a text field for this or if sql will allow me to create a temporary filed each time this report is made.
Case
When T1 = 1 then ‘trigger one is on’
When T2 = 1 then ‘trigger two is on’
When T3 = 1 then ‘ trigger three is on’
When T4 = 1 then ‘trigger four is on’
When T5 = 1 then ‘trigger five is on’
End TR88,
So, if 1, 3, and 5 where checked.. then It would print out:
Trigger one is on Trigger three is on Trigger five is on
TR88 is a text box is a single text box in an Access report.
