I have a report which I have a code that is grouped - I would like to add a blank row after each group to break it up
I have a report which I have a code that is grouped - I would like to add a blank row after each group to break it up
Or how could I put a header for each group by using an if statement for the header names (examples of code 06-D0011, 06-X0011, 06-C0011, etc)
IIf(Mid([WBCode],4,1)="D" - header for group would be DUX
IIf(Mid([WBCode],4,1)="C" - header for group would be Charbonnel
Example:
DUX
06-D0011
06-D0012
06-D0013
Charbonnel
06-C011
06-C012
Last edited by Rhubie; 01-28-2013 at 12:46 PM. Reason: Added an example of what I want to do