counting only footer enties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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]
 
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
 
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
Click to expand...
Click to expand...
 
Back
Top