Seperate long records into two pages in a report

[KevinJason]

I'm trying to make a report that contains records that have alot of
fields. I want the first half of fields to print on one page and then
the second half of fields to print on the second page on the same line
as the record on the first page.

For example say I have 100 records and they have 100 fields. Each page
can hold 10 records and 50 fields. I want the report to print out as
follows:

Page 1:
Field 1 Field 2 ... Field 50
Record 1
Record 2
..
..
..
Record 10

Page 2:


Field 51 Field 52 ... Field 100
Record 1
Record 2
..
..
..
Record 10

Page 3:

Field 1 Field 2 ... Field 50
Record 11
Record 12
..
..
..
Record 20

Page 4:

Field 51 Field 52 ... Field 100
Record 11
Record 12
..
..
..
Record 20

And so on and so forth.

Sorry for the long post. Any help would be appreciated.

 

[Jeff Boyce]

It is rare that a well-normalized relational database would have 100 fields,
let alone as many as 30. There's a chance you are having trouble getting
Access to do what you want it to because you want it to do something it
isn't necessarily designed to do.

One approach might be to review the data normalization and see if the table
structure could be made less like what may reflect a spreadsheet and more
along the lines of what Access is optimized to handle. This could then make
your reporting needs simpler, too.

If you'll post a bit more about what you have in the "100" fields (what kind
of data), the newsgroup readers may be able to offer alternate suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KevinJason]

Thanks for the reply.

Each record refers to the construction of a single house. Each field is
a unique task related to the construction. Each field contains a date.

 

[John Spencer]

So that means you should have a table that has the tasks and the dates for
the tasks. Something like
House(Table)
HouseID
ConstructionType
LotNumber
PlatNumber
....

HouseConstructionTask (Table)
HouseID
TaskID
CompletionDate

TaskList
TaskID
TaskName
TaskSequence

Then you would have one record in the HouseContstructionTask table for each
task that is done building a specific house.

 

[KevinJason]

Thanks John Spencer.

Actually that is how the data is organized more or less. My problem is
with formatting the report. I want the tasks to span two pages for any
given house so that I can put two pages together side by side and get
the task history of a house on one line.

For example:

Page 1: Page 2:

Task 1 ... T x/2 Task x/2+1 ........ T x

House 1 House 1
House 2 House 2
.. .
.. .
.. .
House y House y

And then if there are more houses, the pattern continues on pages 3 and
4, and so on.

 

[Marshall Barton]

I'm trying to make a report that contains records that have alot of
fields. I want the first half of fields to print on one page and then
the second half of fields to print on the second page on the same line
as the record on the first page.

For example say I have 100 records and they have 100 fields. Each page
can hold 10 records and 50 fields. I want the report to print out as
follows:

Page 1:
Field 1 Field 2 ... Field 50
Record 1
Record 2
.
.
.
Record 10

Page 2:


Field 51 Field 52 ... Field 100
Record 1
Record 2
.
.
.
Record 10

Page 3:

Field 1 Field 2 ... Field 50
Record 11
Record 12
.
.
.
Record 20

Page 4:

Field 51 Field 52 ... Field 100
Record 11
Record 12
.
.
.
Record 20

Presumably the report's record source query has the 100
fields in each record. In this case, just make the report's
design wider and anything beyond the page width (paper
width less margins) will be put on a separate page.

 

[KevinJason]

The report isn't wide enough. The fields overlap.

Any other suggestions.

 

[Marshall Barton]

The report can be up to 22" wide. If your 100 text boxes
will not fit on two 11" wide pages, then your goal is
unreasonable.

If your problem is that you don't know how to make the
report wider, then just set the report's Width property to
the desired width or, even easier, drag the right edge of
the design area to the right.

 

[Guest]

KevinJason,
i also need solution to make limit record per page, the the rest record will
go to next page, since the header and footer are same.
pls find the solution

adniza