TOO MANY FIELDS TO CREATE A REPORT? 1

[carlosguill]

I HAVE A LONG DATA SET WITH ABOUT 150 FIELDS, I AM TRYING TO CREATE A REPORT THAT INCLUDES ALL THE FIELDS, BUT I REACHED THE MAXIMUM HEIGHT OF THE DETAIL SECTION, HOW CAN I CREATE A REPORT TO INCLUDE ALL MY FIELDS. THIS SITE HAS PROVIDED ME WITH A LOT OF HELP TO FIGUERE OUT HOW ELIMINATE FIELDS WITH NO VALUES AND GET RED OF BLANK SPACES, BUT NOW I AM STUCK WITH THIS PROBLEM. I'LL APPRETIATE ANY HELP WITH THIS. THANK YOU.

CARLOSG

 

[dhookom]

150 fields is about 125 too many in any of the 100s of applications that I have written. Properly normalized tables generally require no more than about 30 fields.

Can't you just add fields to the left or right of other fields? You can make them mostly small and allow them to grow. You can also use subreports. Another method is to add a grouping and sorting level that is based on a primary key field. Adding group headers and footers on this field is like extending your detail section.

However, this said, you probably have a normalization issue that should be fixed. I could be wrong.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.