Counting Invoices

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I want to count the number of invoices in a report.

I've tried the count() function, but I'm getting the number of line items
rather than just the number of invoices.

I use the GroupHeader for the invoice number and subtotal it on the
GroupFooter. I've tried using the count function on the groupheader or
footer and it still gives the number of line items. I've tried incrementing
an integer in the header or footer and it still gives the number of line
items.

Thanks for your help.
 
In the group header, create a Control, txtRS, with Control Source = 1, Set
its Running Sum property to OverAll. Set its Visible Property to No. Then
print it in the Report Footer by creating a Control txtFinalRS and adding
this code to the Print event of the Control Footer:

Me!txtFinalRS = Me!txtRS

That should do it.

Larry Linson
Microsoft Access MVP
 
Thanks!

Larry Linson said:
In the group header, create a Control, txtRS, with Control Source = 1, Set
its Running Sum property to OverAll. Set its Visible Property to No. Then
print it in the Report Footer by creating a Control txtFinalRS and adding
this code to the Print event of the Control Footer:

Me!txtFinalRS = Me!txtRS

That should do it.

Larry Linson
Microsoft Access MVP
Click to expand...
 
Back
Top