J
Jim Systems
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
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