Count Records in a Report Header Section

[TimTDP]

In Access 2000, I have a report consisting of the 2 headers.
Header 1 is called "PaymentDate"
Header 2 is called "CreditNote"

I need to count the number of records returned in header "CreditNote"
The only field in header "CreditNote" is "CreditNoteId"

e.g, a PaymentDate may have 0, 1 or 4 CreditNotes. I need to know how many.

I have tried including a field in the "CreditNote" footer = count([CreditNoteId]) but this counts the number of records in the reports "detail" section.

I have also tried adding a text box to the Header "PaymentDate" & put the control source as =1 & set the Running sum (under Data) to Over Group / Over All but with no success!

How can I count the number of records returned in header "CreditNote

 

[Remou]

Have you tried DCount?

 

[dhookom]

Doesn't the detail section contain individual credit notes? Isn't this what you want to count?

Can you provide more details about your report and what you want to count?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]