Hi,
I have a report in Access 2003.
The fields are Requestor, Mod and WD.
I need a total for all the patients seen by the requestor and to display only the records of the ones that meet the Mod or WD criteria.
I can get the report to display the Mod and WD but am having some difficulty getting the total count to work.
Thanks,

While there are tons of brilliant individuals who are willing to assist you, it will be difficult for anyone to answer your question without supporting information.

The absolute best way is to (1) create a sample database with confidential information removed if necessary, (2) zip it into a .zip file, and (3) upload it with your questions.

Otherwise, you might have to explain in detail the report's setup and whether its bound to a query, the SQL behind the query, and the table names/fields that you're talking about.

Good luck!

calsteve,

Welcome to UtterAccess!

You could create a group footer for Requestor, and place a textbox in the footer that displays a count of the records for each group.

1. Open your report in Design View.
2. Select View->Sorting and Grouping from the menu
3. In the Sorting and Grouping dialog box, select the Requestor field for the first Field/Expression.
4. Set "Group Footer" to "Yes" in the lower half of the dialog box.

Now your report should have a "Requestor Footer".

5. Place a new textbox in this footer.
6. For the textbox's ControlSource, set it to =Count([Requestor])

That should do it!

Hope this helps,

Dennis

Haha, or you can try that first!

Thanks Dennis!

Thanks, that was a good starting point and I worked the rest out from there...