Append query problem ???

[andrep]

When i try to append the data to the other table i get key violations!
Yet i have no key fields in the destination table ???

Any ideas !
Thanks

 

[CasperTFG]

I need to see your SQL Statement to help with that. Craig, mailto:sander@cogeco.ca
"Procrastination is the art of keeping up with yesterday."
I hope my post was helpful!!!

 

[andrep]

INSERT INTO Vente ( [Code client], [N° commande], [Date commande], SousTotal, SumOfTps, SumOfTvq, SumOftotal, Balance )
SELECT Commandes.[Code client], Commandes.[N° Commande], Commandes.[Date commande], Sum(CCur([Prix unitaire]*[Quantité])) AS SousTotal, Sum([Détails commandes].Tps) AS SumOfTps, Sum([Détails commandes].Tvq) AS SumOfTvq, Sum([Détails commandes].total) AS SumOftotal, Sum([Détails commandes].total) AS SumOftotal1
FROM Commandes INNER JOIN [Détails commandes] ON Commandes.[N° Commande] = [Détails commandes].[N° Commande]
GROUP BY Commandes.[Code client], Commandes.[N° Commande], Commandes.[Date commande];

 

[andrep]

Resolved thanks again!