RE: [AccessDevelopers] Appending Records

Mon, 03 Oct 2005 10:36:12 -0700

Title: Message
I see the error in my ??logic.
De Morgan's Laws of equivalency
 
NOT A AND NOT B would only be true when both A and B are false
 

Glenn P. Jones

 

 

-----Original Message-----
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Eric Douglas
Sent: Monday, 03 October, 2005 11:56 AM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Appending Records

Glenn,
 
If something is "big AND tasty", it need only be not big or not tasty for the original statement to be false.
 
Eric

From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Glenn P MSG (Ret) FL-ARNG
Sent: Monday, October 03, 2005 8:39 AM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Appending Records

NOT does not effect the operator but only the components -
If you logical results are TRUE the opposite would be for your logical results to be false.
NOT A OR NOT B will give a logical result of TRUE.
 

Glenn P. Jones

 

-----Original Message-----
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hoffman, Tobi K (DYS)
Sent: Monday, 03 October, 2005 10:28 AM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Appending Records

Sorry, no.  By rules of logic, your opposite statement will be true in all cases where the original was false, and vice versa, so with A =TRUE and B =FALSE, the original statement is false; therefore the opposite statement will be true in that instance.  So the opposite of A AND B is NOT (A AND B) which expands to NOT A OR NOT B.
 
Tobi
-----Original Message-----
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Glenn P MSG (Ret) FL-ARNG
Sent: Monday, October 03, 2005 10:22 AM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Appending Records

$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.



SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

YAHOO! GROUPS LINKS



Reply via email to