+ Reply to Thread
Results 1 to 2 of 2

"Unpacking" account groups in access

  1. #1
    Registered User
    Join Date
    08-16-2017
    Location
    Romania
    MS-Off Ver
    2013
    Posts
    5

    "Unpacking" account groups in access

    Hello,
    So i have a situation . I have some accounts that belongs to a group.
    I have 2 excel files: one that shows the account group and some other information like to the quota assigned to that specific group and the second excel where i have the information about what contains the account groups ( e.g: 1 account group - contain 20 accounts). Now i want to get a single excel file with this 2 combined. Basically i want to have all the information from the first excel and underneath each account group to see the accounts that belong to it and also all the other information to be dragged down. Like i have mentioned before the quota will be assigned to the account group level which will be for example "x" amount and for the accounts that belongs to the group i want to have the quota written as "0".
    How can i do this in access?
    Is there someone who can help me please?
    I will attach an example of what i want to get to...
    I would also like to mention where the is no account group , to be left as it is .....
    Please let me know if you need more information.
    Thank you so much
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: "Unpacking" account groups in access

    I have looked at what you have presented. What is necessary to take this to the next steps is for you to create a mapping. It appears that the field names in the original data are not the same as in the proposed. Build a mapping with criteria (to include any calculations). Your before does not equate clearly to your needs. Good Luck.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Date in Excel ("30/09/2016") copies incorrectly into Access ("30/05/1905")
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-30-2017, 05:19 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. IF Statement that will assign account types based on "account number"
    By aladdin16 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-08-2014, 05:04 PM
  5. [SOLVED] How to program to account for all choices "ABC*", "*ABC", "*ABC*"
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-20-2014, 03:24 PM
  6. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  7. Managing "delegated tasks" in an Outlook "Send Only" account
    By on_way_to_fame in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 08-13-2013, 12:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1