How do I count :)

[Dave]

Hi

I have a report which lists people's attendance on a course per week (so I
have a line with a name and the number of sessions attended by that person).
I want to have a summary at the bottom of the page listing the number of
sessions followed by the number of people who recorded that number (for
example 10 sessions, 5 people 9 sessions, 6 people). When i run my
original query i ask for an upper and lower date of birth as this is only
applicable to certain people, this means i cant do it as a sub report as i
dont want to type the criteria in twice!

Any idea how i can count???

Thanks

 

[Duane Hookom]

Stop using parameter prompts in your queries. Improve the functionality and
ease of use of your applications by always entering criteria values in
controls on forms. Then you are not prompted more than once.

 

[Dave]

Thanks Duane. The problem is I run the report multiple times based on
different criteria. Having to do this through a form seems the long way
round to do it!

 

[Duane Hookom]

You can open a form hidden and push the values into it. This seems to be the
"short way" compared with repeating parameter prompts.

I have also seen solutions that involve setting global memory variables. You
can then create functions that return those variables. The functions can be
used in your criteria.