Creating a Report with many fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • plaguna
    New Member
    • May 2008
    • 58

    #1

    Creating a Report with many fields

    Does anybody have any idea how to create a Report with 31 columns? ACCESS doesn’t allow me to have a Report with so many fields. It must be in a Tabular Layout.
    Please let me know if you have any hit that I can work on.
    Thank you in advance.
    Plaguna
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Why do you say that "ACCESS doesn’t allow me to have a Report with so many fields?" You can have up to 255 fields or columns. Obviously, if you want 31 of these and you want them in a tabular format, in a normal 8 1/2 x 11 inch hard copy you're not going to be able display much data in any given column, but that's a physical constraint of your paper size and printer. Access does have a width limit of 22 inches, but you'd hardly want a report wider than this, and most office printers cannot handle widths this big.

    I think you're simply going to have to rethink your report design.

    Linq ;0)>

    Comment

    • plaguna
      New Member
      • May 2008
      • 58

      #3
      Thanks for your observation.
      I’m not concerned about the physical constraint of paper size and printer. In other words my question is, how I can increase the default of a Report’s width of 22 inches. The Report that I’m trying to create has 31 fields and 22’’ is not enough. Is there a way to change it?

      plaguna

      Comment

      • Stewart Ross
        Recognized Expert Moderator Specialist
        • Feb 2008
        • 2545

        #4
        Hi Plaguna. Access reports are indeed limited to 22" as Linq said - and a redesign is essential.

        Be clear about this: when we provide advice on this site we try to be as accurate as we can in what we tell you. When Linq said it was a limit he did not mean it was some kind of easily-overcome constraint. It really is an absolute limit.

        You should also consider the needs of your users. If a report needs to be more than 22" (55cm) wide and contain 31 columns I would (1) be unlikely to read it, (2) be unlikely to understand it, and (3) return it for redevelopment.

        Please note given the prevalence of laser printers for printing that unless your printer has A3 paper capability the report would have to be scaled down for printing on A4 in any event.

        -Stewart

        Comment

        • plaguna
          New Member
          • May 2008
          • 58

          #5
          I really appreciate the way you clarify our concerns. Thank for that. This Report is for somebody at work who is convinced that this way should be the best way for him. With the info you guys are giving me, I’ll deal with him, and use another approach for this report.
          Thanks again,

          Plaguna

          Comment

          Working...