C
cchristensen
I am creating a pivot table in Access. When I drag numeric fields into the data area, they appear as grouped, not summed - which is what I want. (The default in Excel is to sum, right?)
I can manually change the setting to sum after dropping the field, but with even a relatively small number of records, the grouping process takes so long it freezes the program.
Is there a way to change the default in Access to sum?
I can manually change the setting to sum after dropping the field, but with even a relatively small number of records, the grouping process takes so long it freezes the program.
Is there a way to change the default in Access to sum?