Help needed with check report.

[TD]

I have a check report that prints checks for our account payable department.
On the report at the bottom i have a sub report that pulls detail
information for the check. For example Check #123 for $1000.00, paid
to......etc. On the bottom of the check the sub report pulls all the
invoices for this check that totals $1000.00. For example Invoice #1 -
$10.00, Invoice #2 - $15.00, etc.

All works well until I run into a check that pays a large amount of
invoices. Currelty there is only room for fifteen (15) invoices to be
listed in the detail section of the sub report at the bottom of the check
report. The problem that happens is that if the check pays more than 15
invoices, say 20 invoices, then the detail of the last 5 invoices rolls over
onto the next check, thus not only ruining a new check (our checks are
preprinted with check numbers), but then causing all future checks to be off
by one check number.

Does anyone know of a way to print my checks, and if the total number of
items exceed 15 that it not print these and somehow instead print these on a
blank sheet of paper instead of a check?

I know it sounds complicated, and it is to me. I'm lost. Any help would be
greatly appreciated.

Terry

 

[Duane Hookom]

You could set the subreport height appropriately to 15 records and set its
Can Grow property to No. Then you would need to create a separate report for
the details that were more than 15 records. I think I would pring all of the
20 records on the blank paper rather than just those greater than 15.

Your main report's record source could join in a query that counts the
invoices per check. Only print those with a count >15.

 

[TD]

Thanks so much for the reply. It gives me a start.

But, I'm lost on how to write a query that counts the invoices per check.

Terry

 

[Duane Hookom]

Without much information about your table structures, you can get the checks
with over 15 invoices with a query like:

SELCT CheckNum, Count(InvoiceID) as NumOf
FROM tblCheckDetails
GROUP BY CheckNum
HAVING Count(InvoiceID)>15;