Results 1 to 2 of 2
  1. #1
    cammyjane10 is offline Novice
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    3

    Merge columns from many tables into one column in new table


    I have 4 tables that store information on guest charges (stayinfo/room rate, fuel charges, bar tab, merch charges) each linked to table carrying guest ID's. Is there a way to combine/merge all the tables into one in such a way that all of the guestID's are in one column, all of the charges are in another column etc? Basically adding one table to the bottom of another

    Thanks

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It sounds like you do not have a normalized table structure.

    Is there a way to combine/merge all the tables into one in such a way that all of the guestID's are in one column, all of the charges are in another column etc?
    To move the records, use append queries.

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

Similar Threads

  1. Replies: 4
    Last Post: 10-15-2012, 02:43 PM
  2. Calculated Columns Same Table And "Column Scrubbing"
    By defaultuser909 in forum Queries
    Replies: 10
    Last Post: 07-19-2012, 11:42 AM
  3. Replies: 6
    Last Post: 01-13-2012, 09:17 AM
  4. Replies: 5
    Last Post: 12-01-2011, 05:38 PM
  5. Replies: 3
    Last Post: 08-08-2011, 11:02 AM

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