How to add a blank row in between dictinct data block in Access Report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • power2005
    New Member
    • Sep 2007
    • 8

    How to add a blank row in between dictinct data block in Access Report

    Hi Experts

    I run into a problem I can't seem to be able to resolve or find the solution to. Basically I have a list of sample data as follow -

    Country Company
    ------- --------

    US Wal Mart
    UK Tesco
    US Exxon Mobil
    UK BP

    I would like to present them in a report with higher readability, so I sort by country and hide the repeated entry in "Country". The result is as follow -


    Country Company
    ------- --------

    US Wal Mart
    ..... Exxon Mobil
    UK Tesco
    ..... BP

    However I also need to add in a blank row or some blank space between distinct country, as follow -

    Country Company
    ------- --------

    US Wal Mart
    ..... Exxon Mobil
    ------ blank row or some blank space ----------
    UK Tesco
    ..... BP

    I couldn't find a way to do this, any input would be highly appreciated. Thanks in advance!

    power2005
  • power2005
    New Member
    • Sep 2007
    • 8

    #2
    Sorry the space doesn't seem to work well... i found out that i can edit the post only after i post this, sorry...

    Data -

    Country Company
    ------- --------
    US Wal Mart
    UK Tesco
    US Exxon Mobil
    UK BP

    Report -

    Country Company
    ------- --------
    US Wal Mart
    ..... Exxon Mobil
    UK Tesco
    ..... BP

    Desired output -

    Country Company
    ------- --------
    US Wal Mart
    ..... Exxon Mobil
    ------ blank row or some blank space ----------
    UK Tesco
    ..... BP


    Thanks!

    Comment

    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387

      #3
      Have you tried grouping by the country and using the Group header to create the space. You can still list the country in the details section if you wish.

      Comment

      • power2005
        New Member
        • Sep 2007
        • 8

        #4
        Hi mmccarthy

        This is exactly what I need! Thank you very much. You made my day!

        power2005

        Comment

        • MMcCarthy
          Recognized Expert MVP
          • Aug 2006
          • 14387

          #5
          Originally posted by power2005
          Hi mmccarthy

          This is exactly what I need! Thank you very much. You made my day!

          power2005
          No problem. Glad it worked for you.

          Comment

          Working...