Results 1 to 6 of 6
  1. #1
    Ragin_roider is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    4

    Dsum Help?

    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...........

  2. #2
    Ragin_roider is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    4
    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.

  3. #3
    kagoodwin13 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    181
    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.

  4. #4
    Ragin_roider is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    4
    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.

  5. #5
    kagoodwin13 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    181
    If you are trying to automate this function, a report with summation in the report footer would be the best way to go.

  6. #6
    Ragin_roider is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    4
    I will automating the all the associated queries in VBA. Thanks for your input on this.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with Sum and DSum
    By objNoob in forum Reports
    Replies: 5
    Last Post: 12-05-2011, 01:55 AM
  2. Problems with DSum
    By Jackie in forum Access
    Replies: 1
    Last Post: 03-27-2011, 05:21 PM
  3. How do I use the DSum
    By Ironclaw in forum Access
    Replies: 1
    Last Post: 08-25-2010, 07:35 AM
  4. Help with dsum
    By bjsbrown in forum Reports
    Replies: 6
    Last Post: 02-06-2010, 09:33 AM
  5. DSUM Problems
    By swampdonkey in forum Forms
    Replies: 2
    Last Post: 09-29-2006, 10:52 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums