Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Derby, Derbyshire, United Kingdom
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combining Tables (2003)

    I have a database containing 2 tables which I need to combine. The tables have the same column headings, with different data. I know next to nothing about access. How does one go about this?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining Tables (2003)

    A simple method would be:
    - Open one of the tables.
    - Select all records (Ctrl+A)
    - Copy to the clipboard (Ctrl+C)
    - Open the other table.
    - Select the new record at the end of the table.
    - Paste the records (Ctrl+V)

    Instead of physically combining the records, it is also possible to create a query that returns the records from both tables (a so-called union query). Post back if you need this.

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Location
    Derby, Derbyshire, United Kingdom
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining Tables (2003)

    I think the query method would be the best. The people using this database know less than me :-)
    Thanks for your help.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining Tables (2003)

    Let's say the tables are named TableA and Table2.
    - Activate the Queries section of the database.
    - Create a new query in design view.
    - Cancel the dialog to add a table.
    - Select View | SQL View.
    - You'll see SELECT;
    - Change this to
    <code>
    SELECT * FROM <!t>[TableA]<!/t>
    UNION
    SELECT * FROM <!t>[Table2]<!/t>
    </code>
    - Select View | Datasheet View to see if the query works.
    - If it does, save it.

    You can use the union query as record source for forms and reports, or as the basis for other queries.

  5. #5
    New Lounger
    Join Date
    Apr 2002
    Location
    Derby, Derbyshire, United Kingdom
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining Tables (2003)

    Thats excelent.
    Thank you very much. Job done.

Posting Permissions

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