ReadOnly ResultSet?

[GJT]

I have written a query that between two tables ORDERDETAILS AND INVOICE LINEITEMS, determines :
for a given job number in ORDERDETAILS - if this jobnumber does not exist in the INVOICELINEITEMS table
i.e. has not yet been invoiced, update the currentqty field with value 'n'

SELECT ORDERDETAILS.CurrentQty
FROM INVOICE_LINEITEMS RIGHT JOIN ORDERDETAILS ON INVOICE_LINEITEMS.OrderId = ORDERDETAILS.JobNumber
WHERE (((ORDERDETAILS.CurrentQty)<>0) AND ((INVOICE_LINEITEMS.OrderId) Is Null))
AND ORDERDETAILS.JobNumber = " & JobNumber

This resulting set appears to be read only - when I attempt to update the CurrentQty I get an error. Why is this and any ideas
how I can get around the problem?

 

[GJT]

Pat

Turning the query round does not make logical sense! I want all orderdetails that do not having an order entry in the invoice details table!

(I tried your suggestions anyway - they made no difference...resultset is still readonly)

this cant be too hard to do.....can it??????