Listing Unlike Items

[Guest]

I have a table based on telephone numbers and customers.
Field 1: Tele#
Field 2: Customer
Field 3: Tele#2
Field 4: Customer

Tele# has dublicates in both Field 1 and Field 3. I want to create a query
which would list all unique Tele#'s. It either appears in Field 1 and not in
Field 3 or Appears in Field 3 and not in Field 1 but not in both.

 

[Guest]

If that what you mean, then try this

SELECT TableName.*
FROM TableName
WHERE [Field 1]<>[Field 3]

 

[Guest]

I have made a change in my database. I have created 2 seperate tables. Each
table has:
Field 1: Tele#
Field 2: Customer

I need the query to list all Tel#'s and Customers in one table which do not
appear in the second table base on Tele#

 

[Guest]

Create a new query, and use the query wizard to create unmatch records in two
tables

 

[Guest]

That's what I needed. I worked great.
THANK YOU!!!!!

 

[Guest]

Your welcome, glad I could help
Good luck

That's what I needed. I worked great.
THANK YOU!!!!!