kirshr123
Active Member
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
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