Need help in scripting


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

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.


1 Like