Hi Arnelgp,
Good idea, however the dates on the qry that calculates the monthly expenses are not a normal dates in that it only shows the month and year from a range of dates, here is my SQL that works out the monthly total expenses:
SELECT DISTINCTROW Format$([tblExpenses].[Date],'mmm yyyy') AS [Date By Month], Sum(tblExpenses.[Home Currency (USD)]) AS [Sum Of Home Currency (USD)]
FROM tblExpenses
GROUP BY Format$([tblExpenses].[Date],'mmm yyyy'), Year([tblExpenses].[Date])*12+DatePart('m',[tblExpenses].[Date])-1;
If I can get the above code to return the same results but include a 'normal date' say the first date of each of the months it returns then I can use this date for the Left join query as suggested above?
Good idea, however the dates on the qry that calculates the monthly expenses are not a normal dates in that it only shows the month and year from a range of dates, here is my SQL that works out the monthly total expenses:
SELECT DISTINCTROW Format$([tblExpenses].[Date],'mmm yyyy') AS [Date By Month], Sum(tblExpenses.[Home Currency (USD)]) AS [Sum Of Home Currency (USD)]
FROM tblExpenses
GROUP BY Format$([tblExpenses].[Date],'mmm yyyy'), Year([tblExpenses].[Date])*12+DatePart('m',[tblExpenses].[Date])-1;
If I can get the above code to return the same results but include a 'normal date' say the first date of each of the months it returns then I can use this date for the Left join query as suggested above?