I have a data similar to this :
saledate >> item >> qty
01.10.2011 >>> pen >> 23
01.10.2011 >>> pencil >> 55
02.10.2011 >> stick >> 45
03.10.2011 >> fevistick >> 25
03.10.2011 >> paper >> 55
04.10.2011 >> magic paper >> 33
04.10.2011 >> small paper >> 21
And I want output e like below : how is it possible in report?
saledate >> qty
01.10.2011 >> 78
02.10.2011 >> 45
total >> 123
03.10.2011 >> 80
04.10.2011 >> 54
total >> 134
i dont know anything about access or report...please let me know how to start off also...thanks