I have the following query:
Code:
SELECT tbl_Clients.Client_Name, IIf(([tbl_Clients].[Active]=True),[tbl_NextMonthsPlan].[Days],Null) AS [Planned Days]
FROM tbl_Clients LEFT JOIN tbl_NextMonthsPlan ON tbl_Clients.Client_ID = tbl_NextMonthsPlan.Client_ID
WHERE (((tbl_NextMonthsPlan.Client_ID) Is Not Null) AND ((tbl_NextMonthsPlan.Payroll_ID)=[Forms]![frm_Weekly_Return]![txt_UserID]) AND ((tbl_NextMonthsPlan.Plan_Date)=[Forms]![frm_Weekly_Return]![txt_NextMonthsDate])) OR (((tbl_NextMonthsPlan.Client_ID) Is Null))
GROUP BY tbl_Clients.Client_Name, IIf(([tbl_Clients].[Active]=True),[tbl_NextMonthsPlan].[Days],Null);
I use this in a continuous form, but I am unable to update the records like this. How can I do this?
This is the query result, so for example, I want to add in 'Planned Days' for other clients or change what is already there, so the 6 to a 4.
thanks in advance.