In the detail section of a report I have a field named "txtDescription". The field's control source is "Description" coming from a query and the query data comes from a table named "txtProjectDetail".
The Description can come from any of the records entered in a table named “tblReprintCodes”.
In the report footer I want to print something like this…
Department #1 count: 12 records
Department #2 count: 6 records
Department #3 count: 0 records
Department #4 count: 9 records
The “Department” needs to be some kind of loop that cycles through the available records in “tblReprintCodes”.
How can I accomplish this?