OK .... in ACCESS, there is a query wizard that will create a query for you
to find "unmatched" records. That is the easiest way to do what you seek.
Try it, and post back with additional questions.
Hi there! Thank You for your answer... I know Access can do almost anything
one can desire, but I have a problem not knowing it's potentials and
functions.
I know the query wizard, and done queries with it, but to accomplish this
problem I am lost.
But thank You for your help.
-elli-
"Ken Snell (MVP)" <kthsneisllis9@ncoomcastt.renaetl> kirjoitti
viestissä:%23GHCFeMNGHA.3788@TK2MSFTNGP09.phx.gbl...
> OK .... in ACCESS, there is a query wizard that will create a query for
> you to find "unmatched" records. That is the easiest way to do what you
[quoted text clipped - 21 lines]
>>>>
>>>> -elli-
Ken Snell (MVP) - 18 Feb 2006 21:39 GMT
What is confusing you in the wizard? It should lead you through each step
fairly easily. You tell it that you want the Computers table to be the
results for the query, then you tell it you want the Users table as the one
that contains the related records, then you select the fields in both tables
that would be related/linked (UserID?), then you specify the fields from
Computers table that you want the query to show you, and then you are done.
Otherwise, assuming that the names I've listed above are correct, this is
the SQL statement of the query to show all Computer records containing a
UserID that does not exist in the Users table:
SELECT Computers.*
FROM Computers
LEFT JOIN Users
ON Computers.UserID = Users.UserID
WHERE Users.UserID Is Null;

Signature
Ken Snell
<MS ACCESS MVP>
> Hi there! Thank You for your answer... I know Access can do almost
> anything one can desire, but I have a problem not knowing it's potentials
[quoted text clipped - 35 lines]
>>>>>
>>>>> -elli-
elli - 18 Feb 2006 21:55 GMT
Thank You Ken very much for your help. The SQL did it, and I could fix two
pieces of info:)) U made my day!
Take care
-e-
"Ken Snell (MVP)" <kthsneisllis9@ncoomcastt.renaetl> kirjoitti
viestissä:Ot3L9ONNGHA.3728@tk2msftngp13.phx.gbl...
> What is confusing you in the wizard? It should lead you through each step
> fairly easily. You tell it that you want the Computers table to be the
[quoted text clipped - 53 lines]
>>>>>>
>>>>>> -elli-