By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,871 Members | 1,617 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,871 IT Pros & Developers. It's quick & easy.

Creating a Report with many fields

P: 58
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.
Sep 8 '08 #1
Share this Question
Share on Google+
4 Replies

Expert 2.5K+
P: 3,532
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)>
Sep 8 '08 #2

P: 58
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?

Sep 8 '08 #3

Expert Mod 2.5K+
P: 2,545
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.

Sep 8 '08 #4

P: 58
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,

Sep 8 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.