How can I make this query editable?

[Domski74]

Hi All

I have a query that I use as the data source for a form but it isn't editable - I need it to be.

here's the query:

SELECT Tbl_PayrollData.Acc_Code_CC AS CC, Tbl_PayrollData.Acc_Code_AC AS SUB, Tbl_PayrollData.Employee_Id AS EMPID
FROM Tbl_SubstantiveStaffLatest RIGHT JOIN Tbl_PayrollData ON (Tbl_SubstantiveStaffLatest.EMPID = Tbl_PayrollData.Employee_Id) AND (Tbl_SubstantiveStaffLatest.SUB2 = Tbl_PayrollData.Acc_Code_AC) AND (Tbl_SubstantiveStaffLatest.CC2 = Tbl_PayrollData.Acc_Code_CC)
WHERE (((Tbl_SubstantiveStaffLatest.CC2) Is Null) AND ((Tbl_SubstantiveStaffLatest.SUB2) Is Null) AND ((Tbl_SubstantiveStaffLatest.EMPID) Is Null));

Please can anyone help?

Thanks

Dominic

 

[Galaxiom]

Most non-updateable problems can be solved by implementing the join as a linked subform.

 

[Domski74]

Thanks for your reply!

The link in the query is to exclude records that exist in both (EMPID, CC and SUB) so it has outer joins with null for those fields - would this work in the way you describe?

Please can you elaborate?

Thanks

 

[Domski74]

Actually it wasn't possible (that I could see) to make this query editable using subforms.

In the end I made the query into a make table and pointed my form at the table instead - meant I had to redesign my db but it did the trick.