John Ruff
papparuff at comcast.net
Fri Mar 5 20:06:25 CST 2004
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