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?