Sub Total in Access Datareport

[BiggerBrother]

I have a database in access that I send an SQL query to. This returns a dataset in groups. I currently display this dataset on a standard datareprot in vb6. I want to add a sub total for each group:

apples 6
pears 12
Fruit 18

carrots 6
veg 6

Totals 24

I currently have the totals set up as a function in the report footer, but now need to add the sub totals function.

Thanks for any help

BB

 

[jonathanmb]

thread222-747042

--
Jonathan

 

[BiggerBrother]

As you can see from the last suggest made in this thread, I have followed the advice and posted in the microsoft database forum.

Any ideas?

 

[jonathanmb]

I'm not a heavy Access Report designer myself... my first thought would be to add a Group Footer band.

My initial reply was only to redirect others who might wish to respond to a post that already had responses.

Good luck.

--
Jonathan