Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2016
    Posts
    7

    Need help with organization Newbie


    I have a huge spread sheet, and I imported it into ACCESS, I would like to take the row which is computer name, which has Multiple entries and combine them into group, and then add the MB size in each column together, is that possible?

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,495
    Sure, create a query with those 2 columns. Click on the Totals icon on the ribbon, then change Group By to Sum on the MB field.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Join Date
    Dec 2016
    Posts
    7
    ok, that worked, is ther a way to tell access, to combine like files, for instance I have a column named File Name, and I want to somehow show that when all the files end in .doc, Combine them and give me the sum of the size, and then also combine them by computername.

    Is it possible?

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,495
    Just doc or group by all the extensions? The first can be done with a criteria. The second would either require the Right() function if all extensions are 3 characters, or more likely a combination of the Mid() and InStr() functions.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Join Date
    Dec 2016
    Posts
    7
    I honestly do not understand, I have not used access in a long time, and I really need a step by step

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,495
    Apparently you decided not to wait, so I'll let any follow up happen here:

    https://www.accessforums.net/showthread.php?t=63231
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Non-Governmental Organization Database
    By spider in forum Database Design
    Replies: 4
    Last Post: 05-23-2013, 05:41 AM
  2. Report Layout Organization Help
    By dylan.greene in forum Reports
    Replies: 5
    Last Post: 09-19-2012, 01:46 PM
  3. Auto Organization?
    By ProjectCamaro in forum Database Design
    Replies: 9
    Last Post: 01-18-2012, 07:00 PM
  4. Report organization
    By kstyles in forum Reports
    Replies: 7
    Last Post: 01-10-2011, 02:47 PM
  5. Organization help needed
    By Logan in forum Database Design
    Replies: 2
    Last Post: 07-30-2010, 11:00 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