Finding First, Last, Second Records

R

r. howell

Each job has a variable number of consultants (ranging from 0 to 5)

The names and addresses of these consultants have to be printed out across
the bottom of a report, in a variable number of columns depending on how many
there are for the job.

I have pretty much given up on doing this so that one report does it all,
and am now reduced to asking the user to click on a button based on how many
consultants are on the job. So far, so good, and the system now works for no
consultants and one consultant.

How do I make sure the query on which a subform is based is picking up the
second (or third) consultant and doing this after the Master/Child linkage
has been established? Hope this makes sense.

Thanks.
 
M

[MVP] S.Clark

In File / Print Setup, you can specify the number of columns for the report.
Not only that, but you can tell it to go horizontal, instead of vertical.
So, click a few settings, and let the report do the rest.

Unless there's something else special about your data.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting
 
R

r. howell

I have tried working with this. I get it to work just fine for the subreport
itself (when it is run as a separate report).

The problem is that the main report has to be one column, while the footer
has the sub-report with three columns.

Others in this forum have told me previously that this combination is not
possible, and my experience in experimenting with this has not found a way to
do it.

I can get three columns throughout, or I can get one column throughout. I
can't seem to make it do the headers and body of the report with one column
and the footer with three columns.

Thanks
 
Top