Append query problem

[Ed3m]

Hello
I am trying to append values from a query to a table but I keep getting key violation error messages.
Thanks

 

[Norie]

Could you explain further what you are trying to do?

 

[Ed3m]

Hello
I have a customer table and an order table. The total cost of the customers orders has been calculated using a query. I now want to move the values for the total cost of the customer orders to a field in the customer table. I have tried this using an append query but keep getting a key violation error.
HTH

 

[Norie]

Why do you want to move them?

You already have them in your query, which you can use in reports, forms and other queries.

 

[Ed3m]

Some customers dont pay for an order straight away so i want to keep adding the cost of the order. I was trying to move the values to customer table and then keep adding the cost of an order so long as it isnt paid for. I basically need a way of keeping check on the total order costs for each customer.

 

[Ed3m]

Some customers don't pay for an order straight away so I want to keep adding the cost of the order. I was trying to move the values to customer table and then keep adding the cost of an order so long as it isnt paid for. I basically need a way of keeping check on the total order costs for each customer.