Results 1 to 4 of 4
  1. #1
    clawschieff is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    4

    Creating a report using the same fields


    Hi all - I have created a report using only 3 fields - Site, Range, Count. The report has over 15,000 records and I would like to print the report. So I added those 3 fields to my report so it looks like: Site Range Count Site Range Count Site Range Count...etc. However, when I view the report the same record is listed on each line. What I would like to do is have each be a unique record simply to minimize the number of pages I have to print. Any suggestions? Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Make the report just the 3 fields wide, then on the Page Setup tab check out Columns.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    clawschieff is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    4
    Thank you...I knew it was something simple!

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 0
    Last Post: 06-15-2012, 05:58 AM
  2. Creating Dummy Fields in a Report
    By Whehir in forum Reports
    Replies: 2
    Last Post: 06-13-2012, 05:45 PM
  3. Creating a query not between 2 date fields
    By daz2932 in forum Access
    Replies: 3
    Last Post: 08-18-2011, 01:39 PM
  4. Creating Custom Fields
    By RudeRam in forum Queries
    Replies: 3
    Last Post: 08-01-2011, 01:09 PM
  5. Creating Report using Text boxes & db fields
    By Nancy J. in forum Reports
    Replies: 13
    Last Post: 07-20-2009, 07:09 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