Thanks both for your help, I ended up solving the problem by adding an ID key to the table and selecting the min ID key when there were equal number of bounce backs for the same supporter.
Cheers,
Tom
Thanks for the reply it worked fine except I now have another problem. If I have a supporter who has 2 different email addresses and they both have 0 bounce backs I need to only select the 1st one in the table!!
Any ideas?
Cheers
Hi,
I am having trouble removing distinct records from the follwowing data:
Supporter email BounceBacks
1 bob@top.com 0
1 bob2@top.com 2
2 sam@fop.com 1
3 jane@lop.com 0
4 dave@pol.com...
Have found out this is a bug with Visual Studio 2005, if you use the report wizard the error occurs so solution is not to use Wizard! There should be a fix for this in the first Service Pack.
Hi,
When creating a report project in Visual Studio I am having problems with datasets created from OLAP. I keep loosing the query if I reopen the dataset to edit, the only way to recover it is to close and reopen the project without saving. I have tried using the query builder and entering my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.