By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,131 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Columns, columns, too many columns

P: n/a
To all:

Here's an interesting one: I have a query that produces 56 (!!) columns
of data. The first three columns are "to repeat at left", as can be
selected in Excel at File --> Page Setup --> Sheet tab. That is, the
first page prints (say) 10 columns. The second page prints the first
three columns, and the next seven columns, and so on. Each page would
do this until all columns are printed.

Access gives a limit to the amount of width available on any given
page, so I don't know how to print this as an Access report. (I could
dump it into Excel, and pick it up from there; I kind of want to use
Access, at least for the moment.) Any other ideas?
Thanks a lot, and Happy Friday!!

Sean

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
st**********@gmail.com wrote:
To all:

Here's an interesting one: I have a query that produces 56 (!!) columns
of data. The first three columns are "to repeat at left", as can be
selected in Excel at File --> Page Setup --> Sheet tab. That is, the
first page prints (say) 10 columns. The second page prints the first
three columns, and the next seven columns, and so on. Each page would
do this until all columns are printed.

Access gives a limit to the amount of width available on any given
page, so I don't know how to print this as an Access report. (I could
dump it into Excel, and pick it up from there; I kind of want to use
Access, at least for the moment.) Any other ideas?
Thanks a lot, and Happy Friday!!

Sean


Landscape on legal-sized paper w/ itty-bitty font size :-)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

P: n/a
2 stupid ideas

1) Is there no grouping possible. If 3 columns are repeated it sounds as
if these are group headers of some sort.
2) Does printing the TextBoxesVertically instead of horizontally any help
3) Is Everybody interested in ALL the data from 56 columns by however
many lines

I said I was stupid

Unsigned in case too many people agree
"MGFoster" <me@privacy.com> wrote in message
news:0U***************@newsread1.news.pas.earthlin k.net...
st**********@gmail.com wrote:
To all:

Here's an interesting one: I have a query that produces 56 (!!) columns
of data. The first three columns are "to repeat at left", as can be
selected in Excel at File --> Page Setup --> Sheet tab. That is, the
first page prints (say) 10 columns. The second page prints the first
three columns, and the next seven columns, and so on. Each page would
do this until all columns are printed.

Access gives a limit to the amount of width available on any given
page, so I don't know how to print this as an Access report. (I could
dump it into Excel, and pick it up from there; I kind of want to use
Access, at least for the moment.) Any other ideas?
Thanks a lot, and Happy Friday!!

Sean


Landscape on legal-sized paper w/ itty-bitty font size :-)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 13 '05 #3

P: n/a
Kinda kludgy... but you could do it with a series of subreports.
Repeat the static columns in each of the subreports, with the "other"
columns and headers being variable between the subreports.

On 7 Jan 2005 17:31:27 -0800, "st**********@gmail.com"
<st**********@gmail.com> wrote:
To all:

Here's an interesting one: I have a query that produces 56 (!!) columns
of data. The first three columns are "to repeat at left", as can be
selected in Excel at File --> Page Setup --> Sheet tab. That is, the
first page prints (say) 10 columns. The second page prints the first
three columns, and the next seven columns, and so on. Each page would
do this until all columns are printed.

Access gives a limit to the amount of width available on any given
page, so I don't know how to print this as an Access report. (I could
dump it into Excel, and pick it up from there; I kind of want to use
Access, at least for the moment.) Any other ideas?
Thanks a lot, and Happy Friday!!

Sean

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.