Results 1 to 2 of 2
  1. #1
    Rhubie is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    85

    Group Spacing

    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

  2. #2
    Rhubie is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    85
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. line spacing in access 2010
    By Alexander Pooh in forum Access
    Replies: 5
    Last Post: 08-15-2012, 08:13 AM
  2. Can't control subreport spacing
    By bonnerm in forum Reports
    Replies: 2
    Last Post: 08-11-2012, 04:30 PM
  3. Convert RTF spacing issue
    By allstar45 in forum Reports
    Replies: 1
    Last Post: 02-28-2012, 07:44 PM
  4. Replies: 1
    Last Post: 01-12-2012, 02:54 AM
  5. Replies: 1
    Last Post: 10-09-2011, 05:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums