hello,
i am trying to create a sales report with
month column headers...
i can get the data to look right by viewing
the datasheet as a pivot table...
now i need to turn that pivot table into a
report.
i tried crosstab queries and about a mile
of vb code.
but i would really like to make reports
from my pivot table data.
thanks,
bipin

bipin wrote:

I found this link to be helpful.
http://www.fmsinc.com/tpapers/access...hly/index.html

i had found the link and have found it to be of great help.
http://www.fmsinc.com/tpapers/access...hly/index.html

crosstab querys will accomplish what i need; however
they are just as messy as a wad of vb code
( which is how the reports are currently being generated.)
they are not easy to change, fix, or even look at.

pivot tables are simple enough for the end user to edit.
so i can provide each user the ability to construct a
custom version of each report.

i am still hoping there is some simple way to generate
a report from a pivot table. otherwise i am probably going
to have to make an elaborate report builder. then i am
gonna have to split every row of data into their own separate
subreports and that is going to obsfurcate my program even
more.

i don't want to give the impression that i am ungrateful.
i am just looking for a little reassurance.

thank you for your reply "Salad"
b

On Apr 16, 4:31*pm, bipin <bipinbi... (AT) gmail (DOT) com> wrote:

Perhaps there is something I don't understand here. A pivot table,
TTBOMK is not t table at all but a query or view of data with the rows
and columns transformed. This is accomplished through sql. Typically
the sql is saved as a query (by those who save queries). A saved query
can be used as the recordsource for a report; so can an sql string.
It's a long time since I've done this with JET, (if i ever did it).
But with SQL Server and Access 2007 one selects the View, the Create
section of the toilet paper (sorry, of course, I meant "ribbon") and
clicks on Report and Presto, a clumsy, inefficient, bloated report
pops right up on the screen. No???????????

Certainly in Access 2000 there is a wizard to help create the crosstab
query.

You may need to create 1 crosstab query for the body (Salesmens names??? and
monthly turnover???) and a second crosstab query for the monthly totals.
Then a Union Query combines these 2 for the final result. If your report is
to be names + 12 monthly columns, then life is very simple. If you want a
variable no of columns to suit only those months that have data, then you
get into quite heavy Vb

Phil

"lyle fairfield" <lyle.fairfield (AT) gmail (DOT) com> wrote

On Apr 16, 4:31 pm, bipin <bipinbi... (AT) gmail (DOT) com> wrote:

Perhaps there is something I don't understand here. A pivot table,
TTBOMK is not t table at all but a query or view of data with the rows
and columns transformed. This is accomplished through sql. Typically
the sql is saved as a query (by those who save queries). A saved query
can be used as the recordsource for a report; so can an sql string.
It's a long time since I've done this with JET, (if i ever did it).
But with SQL Server and Access 2007 one selects the View, the Create
section of the toilet paper (sorry, of course, I meant "ribbon") and
clicks on Report and Presto, a clumsy, inefficient, bloated report
pops right up on the screen. No???????????