IanWaterman
Programmer
I have two datasets and the only way I can join them causes the first set to duplicate on date.
I need to sum the first set of data but only on change of date
eg
31/07/2012 207.31
31/07/2012 207.31
03/09/2012 177.31
03/09/2012 177.31
I want to see a total of 384.62
How do I do that please
Thank you
Ian
I need to sum the first set of data but only on change of date
eg
31/07/2012 207.31
31/07/2012 207.31
03/09/2012 177.31
03/09/2012 177.31
I want to see a total of 384.62
How do I do that please
Thank you
Ian