reports: # of documents in many bundles

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

Guest

I have tbl_bundle which lists all of my bundles. I have tbldocinput that has
all of the documents or records in the system. Many records are related to
a bundle.

I want to do a query whereas I can have a count of bundles assigned
(assigned) to a particular individual on a given date (dateadded) and also
have the total count of documents included in the bundles.

Ie:

Date Added Assigned to Type # of bundles # of documents
in bundles
Jun-13-07 Jean Invoice 3
150
Jun-13-07 Sylvie Invoice 2
50
June-14-07 Sylvie Invoice 4
100

I can get my count to go for the # of bundles hwoever when I try to include
the number of documents in bundles I get a number way out of wack.....not
sure how to proceed with this kind query.

Sincerely,

Jean-Francois Gauthier
 
"Jean-Francois Gauthier"wrote:
I have tbl_bundle which lists all of my bundles. I have tbldocinput that
has
all of the documents or records in the system. Many records are related
to
a bundle.

I want to do a query whereas I can have a count of bundles assigned
(assigned) to a particular individual on a given date (dateadded) and also
have the total count of documents included in the bundles.

Ie:

Date Added Assigned to Type # of bundles # of documents
in bundles
Jun-13-07 Jean Invoice 3
150
Jun-13-07 Sylvie Invoice 2
50
June-14-07 Sylvie Invoice 4
100

I can get my count to go for the # of bundles hwoever when I try to
include
the number of documents in bundles I get a number way out of wack.....not
sure how to proceed with this kind query.
Click to expand...
Hi Jean-Francois,

I'm afraid you might have to provide more details
(tble structures, field names/type, FK/PK, etc) to
get the help you need...

In a general sense, I would attack the problem
using "divide-and-conquer." For example, if tables
were like

tbl_bundle
BID (pk)

tbldocinput
BID (fk)

then one could produce a prequery
(say "qryDocCnt") that counts the
number of docs for each BID.

I would think then that joining this
prequery to your "original query" would
not affect count of bundles, but would
allow summing doc cnts over each group.

Does that make sense?

good luck,

gary
 
Back
Top