Results 1 to 4 of 4
  1. #1
    Chky071 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2015
    Posts
    25

    Access report views a new column the same as a new page?

    I have run a query that reports the following information. I am using Access 2007

    Model (Text)
    Start Time (Time)
    Step (1-5)

    I have a report that is grouped by step and I have Force new page selected for this group. So the idea is that each page will show the models and start times for each step on separate pages.

    Since the width of what I am showing is not very wide I want two columns so that when there is too much data the data will just continue in the next column rather than create a new page. This way all the information for each step will be contained on one page.

    I am running into problems when there isn't enough data for a given step to fill up the entire first column. Access is placing the next data set (Step #2 for example) in the next column rather than on its own page. Does access view a new column as a new page? I thought that selecting "Force new page" for my group would force a new physical page and not just dump the next data set into the next column.

    Does anyone know a way around this?



    Thanks

  2. #2
    Chky071 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2015
    Posts
    25
    Nevermind, solved the problem.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Would you like to share how?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Chky071 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2015
    Posts
    25
    I put all the header information that I wanted under Page Header. I only created the group so that I could have each group of data on a single page. There weren't any fields in the Group Header, since there were no fields I shrunk the size of it down to nothing. I guess when I did this it caused the problem. I went back and made the group header just a little bit bigger. There still aren't any fields in the group header, but that fixed it.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-07-2015, 04:30 PM
  2. Replies: 10
    Last Post: 06-19-2014, 01:51 AM
  3. Replies: 2
    Last Post: 10-15-2013, 09:30 AM
  4. Replies: 9
    Last Post: 10-15-2013, 01:55 AM
  5. Replies: 2
    Last Post: 02-14-2013, 11:25 AM

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