Counting Invoices

[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.

 

[Larry Linson]

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

 

[SAC]

Thanks!

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