1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Finding the Total of Items Seperately-Access

Discussion in 'Business Applications' started by Jason Ess, Dec 29, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. Jason Ess

    Jason Ess Thread Starter

    Joined:
    Sep 4, 2007
    Messages:
    309
    Hello!

    I am using the latest version of Microsoft Access. I have different two different categories, Home and Utilities. Now, I insert values for any payments I make, and will use the drop down box to mark it as Home or Utility. I can add up the SumofAmounts of both the Home and Utilities together, but how does one find the sum of each separately?

    For example, I could see just the total of the Utilities, and then just see the total of the Home payments.

    Sorry, I am really new to Access. Any help would be appreciated!
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    You use the Totals & Group By function.
     
  3. Jason Ess

    Jason Ess Thread Starter

    Joined:
    Sep 4, 2007
    Messages:
    309
    Im not sure I fully understand. I am one of those people that needs explanation! Sorry for the hassle :/

    Here is a pic for help.

    [​IMG]

    As you can see, in the far left column, I have to sets of text, Home and Utility. How would I find the total of each of those separately?

    Step by step haha :)

    Thank you for your patience!
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Unfortunately I do not have Access 2007 to give you a step by step guide.
    But click the Set Square in the top left corner to get the design mode or Design on the Main menu.
    Click on the Summation Symbol (it has Totals written underneath it).
    Now in the new row slect "Group By" for those items you want to group and Sum for those you want to total.
    If you have too many items Grouped you will not get the desired result.
     
  5. Jason Ess

    Jason Ess Thread Starter

    Joined:
    Sep 4, 2007
    Messages:
    309
    Still cant seem to get it.

    Do you know how to do it on 2002. That version?
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    It is basically the same - Query in design View, Main Menu>View>Totals
    In the Totals Row select Group By for those fields you want Grouped and Sum for those to be totalled.
     
  7. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Can you post a Zipped Dummy Access 2002 version?
     
  8. Jason Ess

    Jason Ess Thread Starter

    Joined:
    Sep 4, 2007
    Messages:
    309
    Sure, I tried grouping them, still cant seem to get it though.


    Hope .rar is okay?
     

    Attached Files:

    • db2.rar
      File size:
      20.8 KB
      Views:
      7
  9. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Jason, it looks OK to me, what is wrong with it?
     
  10. Jason Ess

    Jason Ess Thread Starter

    Joined:
    Sep 4, 2007
    Messages:
    309
    I just want to see the total of Home. And then the total of Utility. But not Home and Utility together.


    I feel like I am missing something here.

    I group by, but then when i run it, I still see just the totals together.
     
  11. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    OK, first of all if you want the overall total you should not have the "Expense Sub Cagtegory" column in the query. That will then give you 2 rows, one for Home & one for Utilities.
    If you only want to see one of them you have to tell the query which one to display
     
  12. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Take a look at the attached database.
     

    Attached Files:

    • db2.zip
      File size:
      36.9 KB
      Views:
      13
  13. Jason Ess

    Jason Ess Thread Starter

    Joined:
    Sep 4, 2007
    Messages:
    309
    Wow thats great!

    How did you add the separate queries?

    Thank you SO much!
     
  14. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I added them manually, you need to learn about queries as they power Access.
     
  15. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Finding Total Items
  1. Charmian
    Replies:
    0
    Views:
    526
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/971397

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice