counting only footer enties

L

ld-runner

I understand how to count items and rows, but i need some advise on how to
count the number of footers in a report.
I have Detail that creates a various amount of entries.
i have a Footer that sum's the individual detail.
I have a Report Footer that sums all the detail.
what i want a count entry for is the number of Footers.
Any ideas
 
D

Duane Hookom

Add a text box in your group footer:
Name: txtCountGroup
Control Source: =1
Running Sum: Over All
Visible: No
Add a text box to your Report Footer:
Control Source: =txtCountGroup
 
A

Allen Browne

Add a text box to your Group Footer section, and give it these properties:
Control Source =1
Running Sum Over All
Format General Number
Name txtGroupCount
Visible False

Now add a text box to the Report Footer where you want to show the number of
group footers, and set its Control Source to:
=[txtGroupCount]
 
J

John Spencer

UNTESTED- Going from memory.

Add a control to your summary footer.
Name to the control CountFooterLines
Set its control source to =1
Set its sum to overall
Set its visible property to False

In the Report footer
Add a control
Set its control source to = CountFooterLines
 
L

ld-runner

ahhh, perfect, thank you very much.

Allen Browne said:
Add a text box to your Group Footer section, and give it these properties:
Control Source =1
Running Sum Over All
Format General Number
Name txtGroupCount
Visible False

Now add a text box to the Report Footer where you want to show the number of
group footers, and set its Control Source to:
=[txtGroupCount]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

ld-runner said:
I understand how to count items and rows, but i need some advise on how to
count the number of footers in a report.
I have Detail that creates a various amount of entries.
i have a Footer that sum's the individual detail.
I have a Report Footer that sums all the detail.
what i want a count entry for is the number of Footers.
Any ideas
 
Top