I have the following bug in my grid… in OnRecord I have the following code:
{Lost Hours} = {Target Hours};
And I get the following… WHY does it double the value in Jan and Feb and then throw off the rest of the data. Any idea??
This is my SQL Select Statement:
SELECT
Month(TS_WeekEndDate) as Month,
TS_UserID,
TS_ID
FROM
tblTimeSchedule
WHERE Year(TS_WeekEndDate) = 2023
GROUP BY
Month(TS_WeekEndDate)
I have Month as a field that does manual lookup into Jan, Feb, etc.
