Totals problem with Report

[Guest]

Hi – I’m sure this is really simple but being a total newbie….

Have produced my first report, which breaks down different document types
within ‘batches’ of documents (each batch has a unique number). What I need
is to total up the number of individual batches & this is where the wheels
fall off…..

For example:-

Batch no 1 Doc type A
Batch no 1 Doc type B
Batch no 2 Doc Type A

I need my report to show that 2 Batches had been dealt with but so far have
tried Sum & Count in Design view, neither of which returns the correct result
– instead I’m getting the total number of rows containing the document
records’ – in this case 3.

What I guess it is that I need to know is if there is a method or functions
that can count the total batches but filter out the instances where the Batch
id number is identical.

All advice gratefully received.

Thanks

Jim

 

[Jeff Boyce]

Jim

Perhaps another approach would be to add a "band" (group) in your report for
Batch#. That way, you could add an unbound control to the band's header or
footer and set its source to something like:
=Count([whatever row identifier you have])

Regards

Jeff Boyce
Microsoft Office/Access MVP