totals, (SUM) Grouping Dates Based on an ID....

[mike02]

Hello,

I have A query Setup like this:

ProductID....MonyhlyDate....SumOfNReturn.....SumOf Starting
1...............03/02/2013......-2000.................40,000
1...............03/02/2013......1000..................59,000
1...............03/02/2013......3000..................28,000
2...............02/04/2013......-5000.................10,000
2...............02/04/2013......4000..................80,000
2...............30/04/2013......3000..................200,000
3...............and so on
3...............
3...............




Now for the 2 Sumof.... I am using the Totals In the query from the ribbon... What i want it to do is group the dates into 1...

IE
ProductID....MonyhlyDate....SumOfNReturn.....SumOf Starting
1...............03/02/2013......2000.................127,000
2...and so on..

now I understand Why it doesnt, as the query the data comes from is Defined with a clientID. How can I set up the totals to Sum all numbers in that field with the same corresponding Date?

thanks,

[rzw0wr]

Leave ProductID out of the query.

Dale

[mike02]

I removed the ClientId from the previous query, works good now, thanks for the input!

[rzw0wr]

you are welcome.

Dale