I am trying to perform a Dsum function on the following data below.
Customer Profile Age Disconnect% Total (Dsum)
0000 30 5.0% 5.0%
0000 60 2.5% 7.5%
301 30 1.3% 1.3%
301 90 5.4% 6.7%
etc...........
I am trying to perform a Dsum function on the following data below.
Customer Profile Age Disconnect% Total (Dsum)
0000 30 5.0% 5.0%
0000 60 2.5% 7.5%
301 30 1.3% 1.3%
301 90 5.4% 6.7%
etc...........
To clarify....I need to perform the 'sum' on the Disconnect % column. And have it sum all the records based on the Customer Profile. The above is what I would like the data to look like as a finished product.
The best thing to do might be to create a Report, then put a sum function in the Report Footer. =SUM([Disconnect])
Are you sure you want to sum percentages? Depending on how big your query is, you might end up with a total like 1,250%, which doesn't make any sense.
This really might be a better job for Excel. You could import or copy/paste the data into your Access table.
thanks for the reply.
I need to join this information to another query. So a report would not help.
The % will eventually add up to 100% for every Customer Profile group. I could get this in Excel, but trying to automate this whole process.
If you are trying to automate this function, a report with summation in the report footer would be the best way to go.
I will automating the all the associated queries in VBA. Thanks for your input on this.