Summary Fields

[elwood00]

I have a project database with all objects that have to be worked on for the year. There are three main categories - each object will have one category assigned to it (residential, light commercial and commercial) and then each object has a status (unassigned, scheduled, field completed, submitted, billed). What would be the easiest way to get a quick 360 - how many total, how many of those are residential, light commercial, commercial, how many of each are in what status? So far, I can only think of tackling this with a script, but i would love to just have a window on my form that shows those numbers, since I have plenty of screen real estate.... there has to be an easier way ....no?