Merge Report

[Guest]

I hv to divide my report into two due to this error - Too many fields defined -

How can i merge this 2 reports into one for printing purpose..

TQ

 

[Guest]

How many fields do you have? You have to have an awful lot to get this type
of error (754, added over the life time of a report). If you have much less
than 754, compact the database (Tools > Database Utilities > Compact and
repair database). Create a new report. Open your existing report in design
view and select all objects. Paste these objects into your new report. You'll
need to copy an associated report module, as well, if your report includes a
module.

If you really have a need for this many controls, you probably have a
serious database design issue (ie. not properly normalized) going on. You can
try using subreports to break the fields up.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Alisa K]

test

 

[Guest]

Hi Zyus,

16 fields and 287,000 records should be no problem at all. In fact 2 million
records really shouldn't be a problem (unless you exceed the 2 GB size limit
of a database). I'm still having trouble visualizing why you need to use 230
text boxes but, for the present time, I'm going to stick with my original
recommendation which was to break your report into more manageable
sub-reports, and then add these sub-reports to a main report.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

I hv 16 fields in my main table with 287000 rows of record.

I use Access merely to massage data & produce summary report based on raw
data that i hv imported from other system.

In my report i used about 230 text box with each text box contains of
expression to count or sum based on parameter.

eg Sum(Abs(([LA2]="LN / SAB" And [ARRMTH]=0)))

When i paste so many textbox i started to receive the error.

Thanks