was given as a solution cannot be found. Specifically, i need to be
able to show labels in only the first column of a report! Could
someone please help!
************************************************** ***
Message 6 in thread
From: fredg (fg******@att.net)
Subject: Re: Row headings in a column-based report
View this article only
Newsgroups: microsoft.public.access.reports
Date: 2001-11-20 20:04:31 PST
Travers,
I think this is what you are looking for:
Microsoft KnowldedgeBase Article:
Q148397 'How to show labels in only the first column of a report'
http://search.support.microsoft.com/kb/c.asp
--
Fred
Please reply only through this newsgroup.
I do not reply to direct e-mails.
Travers Kiley <tr********@hotmail.com> wrote in message
news:et4SV3icBHA.1452@tkmsftngp04...
Sure. I would like the report to look like this:
Jan. Feb. Mar. Apr. May. Jun.
Jul. Aug. Sep. Oct. Nov. Dec.
Field #1 R1 R2 R3 R4 R5 R6
Field #2 R1 R2 R3 R4 R5 R6
Field #3 R1 R2 R3 R4 R5 ...
..... R1 R2 R3 R4 et al.
..... R1 R2 R3 R4
..... R1 R2 R3 R4
The fields correspond to the columns configured in the query and the Rx
refers to the records that are returned. Each month's worth of cash flow
data is one record from the query(R1, R2, R3, and so on). Problem is I can't
place any field descriptions (where the "Field #1" and "Field #2", and so on
are) without the report reprinting them for each column. I would like the
field descriptions to be printed once and then just the data printed in the
columns that follow. The column header is easy because it is implicit with
each returned record. But the fields which describe the data I only want
printed once on the far left.
Hope that helps. TK.
*** snipped ***