Is it possible??

[rblivewire]

Can I create a query that looks down one column and matches all values
with the values of a second comlumn. Maybe in a third column it wil
display the results. Also is there a way to go through a column and
change all the endings to a column of data automatically without goin
through each one individually?

 

[Guest]

For the first two parts of the question, yes it is. The classic example is a
tables of employees that has a field for Boss. By doing a self-join on the
table in a query, you can find out who works for a particular boss. The SQL
would look something like:

SELECT Employees_1.BossEmpID AS TheBoss, Employees.*
FROM Employees INNER JOIN Employees AS Employees_1
ON Employees.EMPID = Employees_1.BossEmpID
WHERE (((Employees_1.BossEmpID)=[Employees]![BossEmpID]));

For your last question, you can do an update query; however, we need a lot
more information on what you are trying to attempt. Any action query, such as
append, update, and delete, can be bad news if done incorrectly. Always make
a backup of the table, better yet the entire database, before doing one.

 

[rblivewire]

Thanks ... I have 2 columns ... "CCN" and "CCN from Track list" that I
want to compare. The third column could be named anything. The table is
called FTP. How woul the SQL for this look?

 

[Guest]

SELECT FTP.*, FTP_1.*
FROM FTP INNER JOIN FTP AS FTP_1 ON FTP.CCN = FTP_1.[CCN from Track list]
WHERE (((FTP_1.[CCN from Track list])=[FTP]![CCN]));

See if this is what you want.