Hi,
I have the following query:
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
GROUP BY tbl_Clients.Client_Name, IIf(([tbl_Clients].[Active]=True),[tbl_NextMonthsPlan].[Days],Null);
and get this result (screenshot1):
I need to add in Plan_Date and Payroll_ID parameters from the tbl_NextMonthsPlan table.
I have tried to do this, but keep getting only a list of clients who have days against their name, I still need the full list even if the days is null.
Thanks