Basic Summary Reporting

[kirshr123]

Hi All,

Can anyone give me a very quick lesson in how to summarise on Report Writer (I can do this is Access). What I want to is to be able to summarise invoices that have more than one pay item:

Company Doc Number Pay Item Amount Doc Type

00100 93000179 001 5000 RI
00100 93000179 002 4000 RI

Total 9000

Can I change this so that only one line for 9000 is displayed:

Company Doc Number Amount Doc Type

00100 93000179 9000 RI

Any Help appreciated.

Ian

 

[kavehm]

Level break footers, level break on doc number and use Aggregate totals of the amount, you may wanna hide the display of the more detailed section as well.......

good luck...