Can someone tell me what is wrong with this query?
<pre>INSERT INTO Database_History ( DB2_ID, UserID, Begin_D, End_D, Duration, MachineID )
SELECT Database_History.DB2_ID, Database_History.UserID, Database_History.Begin_D,
Database_History.End_D, Database_History.Duration, Database_History.MachineID
FROM Database_History
WHERE (((Database_History.DB2_ID)="ArDvark")
AND ((Database_History.UserID)="ABZXYSCH"))
AND ((Database_History.Begin_D)=#04/19/2007 11:13:21#)
AND ((Database_History.End_D)=#04/19/2007 11:19:11#)
AND ((Database_History.Duration)=4.0509)
AND ((Database_History.MachineID)="OHW-F23082");</pre>
It does not give me any errors but it comes up and says it is going to "Append



