Search results

It's ok, customer is satisfied with what I have. Thanks

I used a cross tab query in the end to get cumulative totals. Myself and rzw0wr where pming because I posted the db with some private info. I thanked him in those messages. The solution is a bit messy so if you want to have a look at it I can pm you the link. Thanks for responding and thanks...

Apologies for this. I'm desperate

Ok I changed the query and can get results now but they are off the scale wrong. Here is the new code SELECT DISTINCTROW Format(DatePart("m",[InvoiceDate]),"00") & " - " & Format(DatePart("yyyy",[InvoiceDate]),"0000") AS Expr1, Expenses.[Expense Type], Sum(Expenses.Amount) AS [Sum Of Amount]...

Hi all, I really need your help with a query that calculates the cumulative total spent on expenses as each month passes. Here is the query I have written: SELECT DISTINCTROW Format(DatePart("m",[InvoiceDate]),"00") & " - " & Format(DatePart("yyyy",[InvoiceDate]),"0000") AS Expr1...

My name is Karl. I am working on a charity database and I am having problems with cumulative totals on queries at the moment