Hi all,
I am trying to create a report using VB's report writer, that is similiar in style to an income and expenditure statement. I need it to select all the records in a specific table(Access DB) and then allow me to group hem using the group by clause. However once this is done the only function I am able to perform on the records figures is to sum them and get an aggregate sum. However what I need to do is to be able to carry out functions such as add the totals at the end of one group to the total of the next group and then subtract these from the next group by total.
I cannot see how this can be done.
Can I have more than 1 detail section in a report? and maybe manipulate the totals from each different section
Any suggestion greatly appreciated.
Thanks in advance
jpb
I am trying to create a report using VB's report writer, that is similiar in style to an income and expenditure statement. I need it to select all the records in a specific table(Access DB) and then allow me to group hem using the group by clause. However once this is done the only function I am able to perform on the records figures is to sum them and get an aggregate sum. However what I need to do is to be able to carry out functions such as add the totals at the end of one group to the total of the next group and then subtract these from the next group by total.
I cannot see how this can be done.
Can I have more than 1 detail section in a report? and maybe manipulate the totals from each different section
Any suggestion greatly appreciated.
Thanks in advance
jpb
