Hi,

I know this is probably really simple but I just can't get it at this time. I
have an append query that is supposed to append data to a table. The table
has a pk autonumber. It is set to no index. When I run the query it appends
the same data over causing numerous duplicates. I have thought maybe if I set
the date <> the date of the table to be appended that it would work but then
the access errored and said 0 records appended. Do you know how to get this
working?


INSERT INTO AbsenceRecordHR ( [Date], Employee_Name, Absence_Code, Comment )
SELECT [AbTable].Date, [AbTable].Employee, T3.New_AbsenceTypeCode, [AbTable].
[Absence Type]
FROM T3 INNER JOIN [AbTable] ON T3.Old_AbsenceType = [AbTable].[Absence Type]
;

Thanks in advance, Misty

--
Message posted via http://www.accessmonster.com

Misty,

I am confused by this:
"The table has a pk autonumber. It is set to no index."

If it's the pk (Primary Key), then it must be indexed no duplicates -
Access won't allow it to be any other way!

--
Steve Schapel, Microsoft Access MVP

Mitchell_Collen via AccessMonster.com wrote:
> Hi,
>
> I know this is probably really simple but I just can't get it at this time. I
> have an append query that is supposed to append data to a table. The table
> has a pk autonumber. It is set to no index. When I run the query it appends
> the same data over causing numerous duplicates. I have thought maybe if I set
> the date <> the date of the table to be appended that it would work but then
> the access errored and said 0 records appended. Do you know how to get this
> working?
>
>
> INSERT INTO AbsenceRecordHR ( [Date], Employee_Name, Absence_Code, Comment )
> SELECT [AbTable].Date, [AbTable].Employee, T3.New_AbsenceTypeCode, [AbTable].
> [Absence Type]
> FROM T3 INNER JOIN [AbTable] ON T3.Old_AbsenceType = [AbTable].[Absence Type]
> ;
>
> Thanks in advance, Misty
>

Steve Schapel wrote:
>Misty,
>
>I am confused by this:
>"The table has a pk autonumber. It is set to no index."
>
>If it's the pk (Primary Key), then it must be indexed no duplicates -
>Access won't allow it to be any other way!
>
>> Hi,
>>
>[quoted text clipped - 13 lines]
>>
>> Thanks in advance, Misty

You're right, I worded that wrong. My apologies.
thanks, Misty

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200801/1