Append/Update Query

[alexi]

Gday,

I have a little problem im hoping someone can help with. I want to append a figure from a query, to a table that already exists. I need The number from the query to put itself in a column of the same name (actual cost) in a table called tasks, but to be relevant to a jobNo and a Task No. when i append it at the moemnt, it just creates a new record, but doesnt match them up.
Any Ideas?

Ta

 

[dcx693]

Sounds like you need to specify some criteria so that your update query looks for matching JobNo and TaskNo fields. Can you post the SQL code of your query so we can take a look at it?

If you're not sure how to do that, go to your query in design view, go to the View menu and choose SQL View, then copy the text.