This is a simple question if you know sql... any help would rock.
SELECT tbl_Alias.Date, (SELECT Sum([ODX].[IncomeEx]) AS Total FROM [ODX] WHERE ((([ODX].[Date])<=[tbl_Alias].[Date])) AS Total, DLookUp("[Target]","Target") AS Target
FROM ODX AS tbl_Alias
WHERE (((Month([Date]))=Month(Now())));
This looks at all months and income. I want to thell this script that at the end of the month the cumulative starts again.
This possible?
I would also like to include the Target table and column as a cumulative, again just day by day to the end of the month....anyone know the answers?