Summary count multiple fields at once

[ejpvi]

I think I have a workaround to this, but it would involve me creating a lot of unnecessary fields.

I have several fields that are simply counts of the types of calls that came in. They are grouped into their specific areas... orders, returns... etc...

I need to create some summary fields for this data.. So that I can sum together certain fields in their respective groups.... based on the date of the record.

I was thinking I would probably have to create a summary count of each field... then summarize count together those summaries to get the total for that group. That seems like a lot of extra fields... anyone have an alternative?

[LaRetta]

I have several fields that are simply counts of the types of calls that came in. They are grouped into their specific areas... orders, returns... etc...

I guess I don't understand. If calls is a table with a category specifying Orders, Returns etc, and each record has a date, then you can create a summary report counting them (with leading part of Orders, Returns) and also leading part by date range if you wish.

I suspect you shouldn't be using fields but records and maybe even a Group (or Type) field to specify further how they should be grouped together. Without an idea of your structure, it would be difficult to advise further. Can you provide a file showing what you have? :smile2: