Totals problem with Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top