Need help in scripting

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?

1 Like