[AccessD] Don't append if data exist

If the discharge date and client combination has to be unique, create a
unique key on those two fields.  That will keep the duplicate records
out.

Charlotte Foust

-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com] 
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