Connecting Tech Pros Worldwide Forums | Help | Site Map

Columns, columns, too many columns

strauss.sean@gmail.com
Guest
 
Posts: n/a
#1: Nov 13 '05
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


MGFoster
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Columns, columns, too many columns


strauss.sean@gmail.com wrote:[color=blue]
> 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
>[/color]

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

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Phil Stanton
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Columns, columns, too many columns


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:0UHDd.551$pZ4.235@newsread1.news.pas.earthlin k.net...[color=blue]
> strauss.sean@gmail.com wrote:[color=green]
>> 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
>>[/color]
>
> Landscape on legal-sized paper w/ itty-bitty font size :-)
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)[/color]


Jack MacDonald
Guest
 
Posts: n/a
#4: Nov 13 '05

re: Columns, columns, too many columns


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, "strauss.sean@gmail.com"
<strauss.sean@gmail.com> wrote:
[color=blue]
>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[/color]


**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Closed Thread