Results 1 to 4 of 4
  1. #1
    Derrick T. Davidson is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    142

    Limit entries on a report

    I have a report that needs to have a max number of entries as shown below is it possible to have access put items in until line 30 then continue in the columns to the right?
    Serial No. No. of the item Origin Obsevations Serial No. No. of the item Origin Obsevations
    1 12345 Kansas Closed 31 12375 Cottonwood Pending
    2 12346 New York Closed 32 12376 Dewey-Humboldt Pending
    3 12347 Washington Closed 33 12377 Douglas Closed
    4 12348 Bullhead City


    Pending 34 12378 Duncan Pending
    5 12349 Chandler Closed 35 12379 Eagar Pending
    6 12350 Flagstaff Closed 36 12380 El Mirage Pending
    7 12351 Globe Closed 37 12381 Eloy Pending
    8 12352 Lake Havasu City Closed 38 12382 Flagstaff[b] Pending
    9 12353 Mesa Closed 39 12383 Florence[b] Closed
    10 12354 Nogales Closed 40 12384 Fountain Hills Pending
    11 12355 Phoenix Closed 41 12385 Fredonia Pending
    12 12356 Scottsdale Closed 42 12386 Gila Bend Pending
    13 12357 Tempe Closed 43 12387 Gilbert Pending
    14 12358 Tucson Closed 44 12388 Glendale Pending
    15 12359 Apache Junction Closed 45 12389 Globe[b] Pending
    16 12360 Avondale Pending 46 12390 Goodyear Pending
    17 12361 Benson Closed 47 12391 Guadalupe Pending
    18 12362 Bisbee[b] Closed 48 12392 Hayden Pending
    19 12363 Buckeye Closed 49 12393 Holbrook[b] Closed
    20 12364 Bullhead City Closed 50 12394 Huachuca City Pending
    21 12365 Camp Verde Closed 51 12395 Jerome Pending
    22 12366 Carefree Closed 52 12396 Kearny Pending
    23 12367 Casa Grande Closed 53 12397 Kingman[b] Pending
    24 12368 Cave Creek Pending 54 12398 Lake Havasu City Pending
    25 12369 Chandler Closed 55 12399 Litchfield Park Closed
    26 12370 Chino Valley Closed 56 12400 Mammoth Pending
    27 12371 Clarkdale Closed 57 12401 Marana Pending
    28 12372 Clifton[b] Closed 58 12402 Maricopa Pending
    29 12373 Colorado City Closed 59 12403 Mesa Pending
    30 12374 Coolidge Closed 60 12404 Miami Pending

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,046
    That is a multi-column formatted report. Report in design view, Page Setup tab, Page Layout section, Columns.

    Make sure none of the data will wrap as multi-line in textbox. Size Detail section tall enough for 30 records. Have to repeat the column labels horizontally in the header section.
    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.

  3. #3
    Derrick T. Davidson is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    142
    Thank you I think this is what I wanted, however when I follow your directions it shows the header's to the right but it cuts of at 30 records on the left, but no details show up to the right???

  4. #4
    Derrick T. Davidson is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    142
    Sorry I just needed to change the column widths and other details and it works great. THANK YOU so much

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

Similar Threads

  1. Limit report to a range of dates
    By nevets in forum Reports
    Replies: 2
    Last Post: 03-03-2012, 07:13 PM
  2. Limit records on a page of a report
    By bgarey in forum Reports
    Replies: 4
    Last Post: 02-16-2012, 01:42 PM
  3. Limit Report to top 5
    By Nathan Plemons in forum Reports
    Replies: 1
    Last Post: 01-26-2012, 10:55 AM
  4. Limit number of records in report
    By aksnell in forum Reports
    Replies: 3
    Last Post: 12-05-2011, 02:31 PM
  5. Replies: 1
    Last Post: 10-22-2010, 01:29 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 - Senior Forums