Results 1 to 7 of 7
  1. #1
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63

    How to adjust multiple fields on a report?


    I want to print a report for a tracking company. 15 to 20 Trucks/Trailer dispatch every week. I want to print all Dispatch Orders with Order Details on a single report but the problem is that the Orders and Order Details tables have more than 20 fields per Order. How should I justify so many fields and where should I put labels for child table as report gets wider if I put all header and Footer fields in two rows only

  2. #2
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63
    I don't have to print addresses or any other details about customer. Just customer name and details about Order.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    One way would be to put field labels in the page header, ten across on one row, then ten across on another row underneath the first, slightly indenting the second row. Then in the detail section orient 2 rows of text boxes and align the first row with the controls of the first row of labels; the second with the second row of labels. You could put the labels in the section header if there is one, but they would repeat for each section that's repeated. I assume you've already dismissed the ideas of orienting the page as landscape and/or printing on legal size paper.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63
    Thanks for your suggestion, but I don't want repeating labels if there is any other solution available.

  5. #5
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You don't even want the labels to be on each page at the top?

  6. #6
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63
    No, not on top of each page but I don't want repeating labels in details section because if I divide my fields into two rows, I must drag the labels of second row in detail section, and then these labels will be repeated in each record even if some fields or whole row is empty sometime

  7. #7
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Maybe reread my first post. I didn't tell you to put labels in the detail section. I only said to put them in the page header.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-14-2014, 08:08 PM
  2. Replies: 6
    Last Post: 07-02-2013, 11:28 AM
  3. Replies: 3
    Last Post: 06-14-2013, 05:47 PM
  4. Replies: 1
    Last Post: 04-12-2013, 03:03 PM
  5. Report based on Multiple Date Fields
    By viper210 in forum Reports
    Replies: 11
    Last Post: 09-27-2012, 07:07 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