[AccessD] Re: Don't append if data exist

Create a unique index on the two columns.
This will keep a new record from being added.

Robert


At 10:54 AM 3/5/2004 -0600, you wrote:
>Date: Fri, 5 Mar 2004 07:48:41 -0800 (PST)
>From: Lonnie Johnson <prodevmg at yahoo.com>
>Subject: [AccessD] Don't append if data exist
>To: "'MS-ACCESS-L at lists.missouri.edu'" <ms-access-l at po.missouri.edu>,
>         AccessDevelopers <accessdevelopers at yahoogroups.com>,    ms_access
>         <ms_access at yahoogroups.com>,    "AccessD solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <20040305154841.28969.qmail at web20413.mail.yahoo.com>
>Content-Type: text/plain; charset=us-ascii
>
>
>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