[AccessD] Don't append if data exist

Make the Discharge Date and the Client Number the Primary Key

John V. Ruff - The Eternal Optimist :-) 
Always Looking For Contract Opportunities 

Home: 253.588.2139 
Cell: 253.307/2947 
9306 Farwest Dr SW 
Lakewood, WA 98498 

"Commit to the Lord whatever you do, 
                and your plans will succeed." Proverbs 16:3 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
Sent: Friday, March 05, 2004 7:49 AM
To: 'MS-ACCESS-L at lists.missouri.edu'; AccessDevelopers; ms_access; AccessD
solving'
Subject: [AccessD] Don't append if data exist



I have a query that runs every morning. It appends records to a table if a
DISCHARGE DATE falls within the current month. Each day it will duplicate
records for a CLEINT. How do I NOT append a record if BOTH the CLIENT NUMBER
and the same DISCHARGE DATE exist. Note it is possible for a person to be
discharged twice in one month. That is ok as long as the dates are
different.

I can't seem to think this through.

Please help me think today 





Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 




---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you're looking for faster.
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com