RE: [AccessDevelopers] Appending Records

Mon, 03 Oct 2005 07:21:07 -0700

Title: Message
$0.02
 
Actually, you have indicated the grammatical reverse but not the logical reverse.
 
"A AND B" indicate you need both A and B to satisfy a situation.
Using "Not A OR Not B" would still satisfy the logic for the situation unless all inputs are either A or B
"Not A AND Not B" would disallow satisfaction for a situation.
 
If you draw a simple diagram with switches and a light bulb you can easily prove your logic.
An AND statement puts the switches in series and the OR statement puts the switches parallel
 
If you say something is big and tasty then the opposit of that would be that it is not big and it is not tasty.
If you say it is not big or it is not tasty than means that if it is not big it could be tasty and if it is not tasty it could be big.

Glenn P. Jones

 

-----Original Message-----
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly
Sent: Friday, 30 September, 2005 5:48 PM
To: AccessDevelopers@yahoogroups.com
Subject: Re: [AccessDevelopers] Appending Records

Actually, on the query, go with Tom's suggestion.  Use the Left Join and then check for Null ID.
 
Either way will work (I'm not sure if there is any performance advantage one way or the other) but Tom's route involves little messing with the query.
 
My suggestion was based on some logical law (I can't remember its name) that says the inverse of
A And B
is
(Not A) OR (Not B)
 
In English, that means that the opposite of
Big And Tasty
is
(Not Big) OR (Not Tasty)
 
;-)
Toby
----- Original Message -----
Sent: Friday, September 30, 2005 2:39 PM
Subject: Re: [AccessDevelopers] Appending Records

' Update Contact Details
Dim db As DAO.Database
Dim results As DAO.Recordset
 
Set db = CurrentDb
Set results = db.OpenRecordset("your query from your email here")
 
While Not results.EOF
    db.Execute("INSERT INTO tblContactDetails VALUES(" & results!IngClientID & ", <<txtContactType here>>")
    results.MoveNext
Wend
 
***Query to find reverse of query in your email***
SELECT tblClientInfo.lngClientID
FROM [ExportToMasterClient - 2005 EL Seminar], tblClientInfo
WHERE ([ExportToMasterClient - 2005 EL Seminar].[Last Name] <> tblClientInfo.txtLastName)
OR ([ExportToMasterClient - 2005 EL Seminar].[First Name] = tblClientInfo.txtFirstName)
OR ...
 
The above query will find all records where there is any field that DOESN'T match.
 
HTH,
Toby
 
----- Original Message -----
Sent: Friday, September 30, 2005 1:58 PM
Subject: [AccessDevelopers] Appending Records

I have a master client contacts database.  There are three tables:  tblClientInfo, tblContactDetails, tblContactTypes
 
tblClientInfo has a pk of lngClientID (autoNumber)
tblContactDetails has the foreign key of lngClientID & foreign key of txtContactType (joining to tblContactTypes)
 
I also have many Seminar databases used for registering people to attend the various seminars that our firm provides.
 
Now, the Marketing Manager wants the attendee's of the seminars to be migrated into the Master Client Database.  On the surface, not really a problem.  However,
 
1.    I don't want to duplicate people in the Client db.  (Clients can attend more than one seminar)
2.    I do want to locate the client and update their Contact Details to reflect that they have attended a certain seminar.
 
I can identify the clients that are already in the database by using the following query:
 
SELECT tblClientInfo.lngClientID
FROM [ExportToMasterClient - 2005 EL Seminar] INNER JOIN tblClientInfo ON ([ExportToMasterClient - 2005 EL Seminar].[Last Name] = tblClientInfo.txtLastName) AND ([ExportToMasterClient - 2005 EL Seminar].[First Name] = tblClientInfo.txtFirstName) AND ([ExportToMasterClient - 2005 EL Seminar].Title = tblClientInfo.txtTitle) AND ([ExportToMasterClient - 2005 EL Seminar].Organization = tblClientInfo.txtCompanyName) AND ([ExportToMasterClient - 2005 EL Seminar].Address = tblClientInfo.txtAddress1) AND ([ExportToMasterClient - 2005 EL Seminar].City = tblClientInfo.txtCity) AND ([ExportToMasterClient - 2005 EL Seminar].State = tblClientInfo.txtState) AND ([ExportToMasterClient - 2005 EL Seminar].ZipCode = tblClientInfo.txtZip);
 
What I don't know how to do is using this information add a record for the tblContactDetails.
 
I also do not know how to get the reverse of this query so I can append new clients into the database. 
 
Suggestions?

Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
 



Please zip all files prior to uploading to Files section.


YAHOO! GROUPS LINKS



Reply via email to