greetings

I have a report based on a Crosstab query. Both the Query and the Report
work just fine. They have 2 row headers on the left side of the table and a
variable number of PivotField headers.

I've been asked to have the Report's table in a grid when printed. Normally
I would just use line segments to draw this grid. BUT, the number of
PivotFields varies from Report to Report, so I'm having difficulty getting
the grid to work. My supervisor wants the grid to end with the LAST COLUMN.
I'd like to know:

a) What is the best way to compute how many Pivotfields a Query will have?

b) How should I approach the drawing of the grid?

thank you in advance for any tips. I'm not experienced enough at coding to
know how to handle this properly.
Sarah

First, how are you creating your report if your number of columns will vary?
Have you thought about just using the border of the text boxes to create the
grid?
It might help if you provided the SQL view of the crosstab.
--
Duane Hookom
MS Access MVP


"Sarah" <(E-Mail Removed)> wrote in message
news:0B6AFF7D-1B10-42F6-8948-(E-Mail Removed)...
> greetings
>
> I have a report based on a Crosstab query. Both the Query and the Report
> work just fine. They have 2 row headers on the left side of the table and
> a
> variable number of PivotField headers.
>
> I've been asked to have the Report's table in a grid when printed.
> Normally
> I would just use line segments to draw this grid. BUT, the number of
> PivotFields varies from Report to Report, so I'm having difficulty getting
> the grid to work. My supervisor wants the grid to end with the LAST
> COLUMN.
> I'd like to know:
>
> a) What is the best way to compute how many Pivotfields a Query will have?
>
> b) How should I approach the drawing of the grid?
>
> thank you in advance for any tips. I'm not experienced enough at coding
> to
> know how to handle this properly.
> Sarah
>

hi Duane
The number of columns varies because the table is based on a Crosstab query,
so the number of PivotFields can be more or less. In any case, I've found
that the max number of Pivotfields is 16, so I've decided to make the grid
that size and leave 'squares; blank if not needed. Thank you for your
assistance. -Sarah

"Duane Hookom" wrote:

> First, how are you creating your report if your number of columns will vary?
> Have you thought about just using the border of the text boxes to create the
> grid?
> It might help if you provided the SQL view of the crosstab.
> --
> Duane Hookom
> MS Access MVP
>
>
> "Sarah" <(E-Mail Removed)> wrote in message
> news:0B6AFF7D-1B10-42F6-8948-(E-Mail Removed)...
> > greetings
> >
> > I have a report based on a Crosstab query. Both the Query and the Report
> > work just fine. They have 2 row headers on the left side of the table and
> > a
> > variable number of PivotField headers.
> >
> > I've been asked to have the Report's table in a grid when printed.
> > Normally
> > I would just use line segments to draw this grid. BUT, the number of
> > PivotFields varies from Report to Report, so I'm having difficulty getting
> > the grid to work. My supervisor wants the grid to end with the LAST
> > COLUMN.
> > I'd like to know:
> >
> > a) What is the best way to compute how many Pivotfields a Query will have?
> >
> > b) How should I approach the drawing of the grid?
> >
> > thank you in advance for any tips. I'm not experienced enough at coding
> > to
> > know how to handle this properly.
> > Sarah
> >