I have created a report that serves as an audition schedule for my arts organization. It pulls records that have an audition status of X based upon a numerical value, and works just fine. Example:
John Doe Pittsburgh, PA 412.422.1092
Jane Doe Export, PA 724.299.2000
What I would like Access to display is a simple count of how many records show up in the report. Ideally the report would look like this:
1 John Doe Pittsburgh, PA 412.422.1092
2 Jane Doe Export, PA 724.299.2000
I use these numbers for planning purposes-to estimate how many people I can do in one day, and to tell the audition committee (those who hear the audition) how many people we have attending, in total, for the audition. Up until now this report has been done by hand through MS Excel, and I want to convert over solely to a MS Access report from now on. However, I really need this counting function to work. Ideally, it would look like the second example, but that's not critical, as long as I have some way for the report to display how many records are displayed on the report (how many people are scheduled for that day, essentially).
Any thoughts? Thanks for anyone's help in advance.
Andrew from Pittsburgh