October 13, 200916 yr 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?
October 13, 200916 yr 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:
Create an account or sign in to comment