Skip to main content

Hi,


I have one table where we collect all the facilities requirements from various departments.


I need the output like for each facility item what is the total count


How to do that with scripting


Can someone help me


Regards

Sridhamasakha Dasa


Um, can’t you set a Group By on facilities requirements and then see all the counts?


If you had a way to tabulate the counts in a Script Block, what then? Post them to a new summation table? If this is you plan, I believe you can create a roll-up to achieve the same outcome and all without script.


Thoughts?


Reply