2 Replies Latest reply on Nov 26, 2013 7:15 AM by philmodjunk

    Run calculation for each field in a table?



      Run calculation for each field in a table?




           I am wondering if I can run a calculation for each field that is in a table? I have a table with a bunch of fields that are checkboxes. If checked, they equal 1. 

           I want to go through each field, and if it equals 1, I want to show it on a report. If it doesnt equal 1, I dont want to show it at all. Assuming I can do that, I will need a way to figure out how to display the field name in a better way, because the way I have them saved internally is not how I would want to display them. Is it possible to access the comments of a field through calculation code somehow? This way I could enter the way I want them to display as a comment and use that in my report?


           Thoughts on how I could implement this? Thanks!