Results 1 to 4 of 4
  1. #1
    cadeucsb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    3

    Transpose Data from Row to column format help needed

    I have a table of account number data. The table includes a field for Account Number and a field for Master Account Number.



    The master account number is an aggregator of account numbers so we know which account numbers go together for one vendor/client/etc.

    The problem I have is an account can have 2 master account numbers. So essentially this account number will be in my table twice (once for each master#).

    My hope is to get each account number into the table once with an additional Master Account #2 field. I have been racking my brain and cant think of a way to execute it.

    any help is greatly appreciated.

  2. #2
    ketbdnetbp is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Midwest
    Posts
    254

    cadeucsb -

    A few questions??

    You stated: The master account number is an aggregator of account numbers so we know which account numbers go together for one vendor/client/etc.

    Question: What do you mean by, "aggregator of account numbers"?
    Is this a series of numbers separated by a comma or semi-colon, etc. OR is this field based on logic or a particular formula OR is it something else?

    Further, you also stated: The problem I have is an account can have 2 master account numbers. Question: Why and when does this occur?

    Once this information is known, more specific help can be provided.

    All the best,

    Jim

  3. #3
    cadeucsb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    3
    Quote Originally Posted by ketbdnetbp View Post
    A few questions??

    You stated: The master account number is an aggregator of account numbers so we know which account numbers go together for one vendor/client/etc.

    Question: What do you mean by, "aggregator of account numbers"?
    Is this a series of numbers separated by a comma or semi-colon, etc. OR is this field based on logic or a particular formula OR is it something else?

    Further, you also stated: The problem I have is an account can have 2 master account numbers. Question: Why and when does this occur?

    Once this information is known, more specific help can be provided.

    All the best,

    Jim

    With the data, it is a set table of info. No logic or formula or csv loads etc. its an existing table with fields: Account Number and Master Account Number.

    To further explain the data...

    lets say youre a client with 5 account numbers: 1,2,3,4 and 5.
    Now on top of that we would have 1 master account number: 99.

    Accounts 1,2,3,4,5 are all under this 99 Master account so we know which 5 belong to you. So if someone asks, which are Jim's accounts, I dont have to get a list of all 5 accounts numbers, I can just say Master Account 99.

    See the attached to better explain the current data layout and what I am trying to do.

    cade

  4. #4
    cadeucsb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    3
    anyone else have thoughts on this? been manually dealing with this for years and would love to fix it on the db table side.

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

Similar Threads

  1. Transpose specific records to table (VBA)
    By KP_SoCal in forum Programming
    Replies: 2
    Last Post: 02-27-2013, 09:31 PM
  2. Replies: 4
    Last Post: 08-19-2011, 01:53 PM
  3. Replies: 20
    Last Post: 02-14-2011, 10:55 AM
  4. avg/min/max data help needed badly
    By donavan01 in forum Access
    Replies: 7
    Last Post: 02-13-2011, 12:49 PM
  5. Please Help, How Do I Format this Data?
    By txdave36 in forum Access
    Replies: 6
    Last Post: 09-09-2009, 04:31 PM

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