Add horizontal line after a change in detail

[Mr-Re Man]

I have a report that displays outstanding invoices by officer, what I would
like to do is visually group invoices together by officer. I have sorted
them out, that was easy, but what I would like to do next is to seperate
officers by having a horizontal line between records.
eg.
________________________
1234 John Smith
2345 John Smith
________________________
3456 Paul Jones
4567 Paul Jones
________________________
5678 Charlie Williams
________________________

thank you

 

[John Spencer]

In report design view, select View: Sorting and Grouping from the menu
In Field/Expression enter the name of the field that contains Officer
Set Group Footer to yes or Group Header to Yes
Close the dialog
Use the line tool to draw a line in the footer (or header)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County