Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Location
    Blakeslee, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How Do I (Access 2000)

    I was wondering if there is a way I can find matching records between to tables and append them to a blank table like I can with the unmatched query in the query wizard. I have to tables with Name, Address, City, State, Zip and Phone number. I wanted to find only the records in the 2 tables that have the same phone number. Thank you in advance for any help I can get. Please email me at guidera@epix.net

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I (Access 2000)

    Create a new query that contains both tables. Drag the phone number from one table into the other table to create a JOIN between them. double-click the asterisk from one of the tables to indicate that all the fields should be shown in the query. Run the query. the resulting records are the ones in which the phone numbers are equal.

    return to the query design and change the query into a MakeTable query. Run the query, and it will create the new table for you.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  3. #3
    Star Lounger
    Join Date
    Oct 2001
    Location
    Blakeslee, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I (Access 2000)

    Thank you very much......I knew it had to be something easy but man it was driving me nuts!

    Thank you again!!!

Posting Permissions

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