hi there,

Hope that someone could help me on this. I have a problem in creating an accounting report in VB6. My report will look like this

Year Date Amoun
2000 17/02/00 200
18/02/00 300
2001 20/02/01 50
29/03/01 600
30/04/01 700

My database will only have date and amount fields.The problem is how to avoid the Year value from repeating.