Hi,
I need help converting from SQL to VBA, can anyone help please. Thank you very much.
TRANSFORM Sum([Overtime Records].Duration) AS SumOfDuration
SELECT [Overtime Records].Officer, Sum([Overtime Records].Duration) AS [Total Of Duration]
FROM [Overtime Records]
GROUP BY [Overtime Records].Officer
PIVOT [Overtime Records].Status;
TRANSFORM Sum([Off-in-Lieu records].[Number of hours of off taken]) AS [SumOfNumber of hours of off taken]
SELECT [Off-in-Lieu records].Officer, Sum([Off-in-Lieu records].[Number of hours of off taken]) AS [Total Of Number of hours of off taken]
FROM [Off-in-Lieu records]
GROUP BY [Off-in-Lieu records].Officer
PIVOT [Off-in-Lieu records].Status;
Thanks you.
Best Regards.
David Yam