Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Insert Line Every X Records (XP)

    Is there a way to insert a blank line (in a report) every 5 records? One that a real newbie, non-programmer could actually do? I migrated from Paradox and there was an option for reports to do just that, so no programming necessary.

    Thanks again. You guys are the greatest!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Insert Line Every X Records (XP)

    I'm sorry, this requires a little bit of programming in Access. It is not very difficult, though. There is a Microsoft Knowledge Base article that gives detailed instructions: ACC2000: How to Print a Blank Line Every Nth Line in a Report (although the title mentions Access 2000, it works exactly the same for Access 2002/XP.) You can also download a useful database with lots of sample reports from a link in this article.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Insert Line Every X Records (XP)

    Thanks, Hans. I don't mind tackling programming if my hand is being held. Coming up with code on own doesn't usually work. This looks like I should be to figure out how to do it. I'll have to study the KB article and sample db.

    Appreciate the help!!

  4. #4
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Insert Line Every X Records (XP)

    Hey, Hans! I actually did it! Enough hand-holding even for me (after I figured out where the Object box was) and it worked! Programming is lots different than when I was working with Apple (//e) Pascal.

    And the downloaded sample reports seem to have tons of info I can use. What a resource.

    THANK YOU!! I really appreciate your finding the KB article for me. I am in heaven. What a great way to start the weekend!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Insert Line Every X Records (XP)

    That's great! It's always nice if you can make it work yourself.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Insert Line Every X Records (XP)


  7. #7
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Insert Line Every X Records (XP)

    Oh goody! I love samples that I can learn from. Thanks for finding them. I will download and work with them...next week. Too much excitement for one week getting 2 reports to work properly!

    Peggy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •