 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2005How do I count :)
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 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.  SignatureDuane Hookom MS Access MVP > Hi > [quoted text clipped - 10 lines] > > Thanks 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! > Stop using parameter prompts in your queries. Improve the functionality > and ease of use of your applications by always entering criteria values in [quoted text clipped - 14 lines] >> >> Thanks 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. SignatureDuane Hookom MS Access MVP -- > 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 [quoted text clipped - 18 lines] >>> >>> Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.