[AccessD] Append Query Not Appending

Set your code to Docmd.setwarnings true, and see if you're getting an error
message on key violations.

-----Original Message-----
From: Bryan Carbonnell [mailto:Bryan_Carbonnell at cbc.ca] 
Sent: Tuesday, March 02, 2004 9:53 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Append Query Not Appending

I have created  an append query that is basically moving data from one
table to a similarly structured table, minus a few fields in the new
table.

When I run the query, I get most of the records transfered, but not all
of them.

I have tried to manually add a few of the records and that works. I'll
be d*mned if I can figure out why the append query won't work.

Any ideas?

BTW, here is the SQL that is almost working :)

INSERT INTO tblFault ( FaultID, FaultDate, FaultTime, FaultProgram_FK,
FaultLocation_FK, FaultLocationDescription, FaultReason_FK,
FaultReasonDescription, FaultDescription, FaultPerson_Fk )
SELECT Fault.ID, Fault.Shift_Date, Fault.Time, Fault.Prog, Fault.Loc,
Fault.Loc_Desc, Fault.Reason, Fault.Res_Sub, Fault.Description,
Fault.Resource
FROM Fault

ANy ideas will be greatly appreciated.

Bryan Carbonnell
bryan_carbonnell at cbc.ca
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com