Payslip Report

  • Thread starter Thread starter Steve McNaught
  • Start date Start date
S

Steve McNaught

Hi.

I am using Microsoft Access to generate a report in the
style of a payslip.

I have sections outlined with fixed size boxes and when a
particular section has too many records it needs to flow
onto another page (exactly the same as the previous page)
with the additional records.

ie.

Page 1
_________________________
-----------
|row 1 |
|row 2 |
|row 3 |
-----------
<other information>
_________________________


Page 2
_________________________
-----------
|row 4 |
|row 5 |
|row 6 |
-----------
<other information>
_________________________

I need to be able to do this within one report.

Any help you could give me would be greatly appreciated.
Email me ([email protected]) if you feel you
could help me out..

Thanks.
 
The report has other information between the fixed box
and the next page. I need the rows of information to
overflow into a fixed box on page 2 from page 1.

Page 1
_________________________
Box 1
-----------
|row 1 |
|row 2 |
|row 3 |
-----------
Box 2
---------------------
| <other information> |
| |
---------------------
_________________________

Page 2
_________________________
Box 3
-----------
|row 4 |
|row 5 |
|row 6 |
-----------
Box 4
---------------------
| <other information> |
| |
---------------------
_________________________

The information from box 1 needs to flow on to box 3 when
it reaches a certain number of rows. It then needs to
flow to a box 5 when box 3 fills up and so on...
 
Is your issue similar to having a set section of the page that list possibly
hundreds of customers so that multiple pages are required? Your page footer
would contain a list of employees which would overflow on to 2nd, 3rd, ...
pages without repeating the same employees at the bottom of each page?

I assume the "other information" is a collection of records. Are these
always the same height?
 
Back
Top