matches columns for two separate tables

G

Guest

Query to find like numbers in columns that are in two separate tables? For
example, I have one table with telephone numbers in a column and I want to
see the matching telephone numbers in a column in a separate table.
 
J

John Vinson

Query to find like numbers in columns that are in two separate tables? For
example, I have one table with telephone numbers in a column and I want to
see the matching telephone numbers in a column in a separate table.
Click to expand...

That's exactly what relational databases are designed to do!

Create a Query using the New Query option. Add the two tables to the
query window. Drag the field on which you wish to join from one table
to the other. Select whichever fields you want to see from the two
tables; save the query, and open it by either clicking the leftmost
toolbar icon or by doubleclicking the query name in the Queries
window.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INNER JOIN query 1
cross reference tables using a query 4
Checking if data exists another table and, if yes, extracting a value 0
Word Create a Phone Book using MailMerge in word 2007 0
Finding possible matches 8
MS ACCESS INVENTORY CALCULATION 0
Query that will look for duplicate in two tables. 3
EMERGENCY! How can I update one table from another in a select que 5

Top