Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / February 2006

Tip: Looking for answers? Try searching our database.

Query to solve if...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
elli - 18 Feb 2006 18:42 GMT
I have two tables. I want to check if the Computer -table's User ID  exicts
in User table. Probably very simple..., but so am I..;)

-elli-
Ken Snell (MVP) - 18 Feb 2006 19:12 GMT
How do you want to use this value? Where are you wanting to look it up? That
will help us help you to use the appropriate approach.

>I have two tables. I want to check if the Computer -table's User ID  exicts
>in User table. Probably very simple..., but so am I..;)
>
> -elli-
Signature


       Ken Snell
<MS ACCESS MVP>

elli - 18 Feb 2006 20:09 GMT
I've been doing a new database from a huge and messy 1-2-3  with multiple
entries with some smalla differencies. While cleaning the table, I might
have left some of the Computers with a user ID that doesn't exist in User
table anymore, because I 'cleant' it. I mean there where same
User name with many ID-numbers, and I changed in the computer table them to
be the same and deleted the 'overcomes' from the User table. Just need to
check that there aren't any computers without an existing user.

Sorry my messy explanation....

-elli-

"Ken Snell (MVP)" <kthsneisllis9@ncoomcastt.renaetl> kirjoitti
viestissä:OajUx8LNGHA.1760@TK2MSFTNGP10.phx.gbl...
> How do you want to use this value? Where are you wanting to look it up?
> That will help us help you to use the appropriate approach.
[quoted text clipped - 3 lines]
>>
>> -elli-
Ken Snell (MVP) - 18 Feb 2006 20:12 GMT
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.

Signature

       Ken Snell
<MS ACCESS MVP>

> I've been doing a new database from a huge and messy 1-2-3  with multiple
> entries with some smalla differencies. While cleaning the table, I might
[quoted text clipped - 17 lines]
>>>
>>> -elli-
elli - 18 Feb 2006 21:27 GMT
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-
elli - 18 Feb 2006 20:11 GMT
I forgot to mention that I don't need it it more than once. And can do the
fix manually, just need to now those ComputerID's without a proper User..

-e-
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.