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
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