USING Crosstabs results -- how do you get it into a form or report ?

[John Baker]

Hi:

While the crosstabs capability appears very powerful, I don't see how I can get the
information into a form or anything else. Is there some way I can do a cross tabs, and
then use the result? Whenever I try I find that there is no data available, unlike regular
queries, forms and reports

Any help would be appreciated.

Regards

John Baker.

[Ben Eaton]

There's a good example of how to print a crosstab report in the Developer
Solutions example (should be somewhere in the Acces help files, failing
which it is somewhere on the MS website).

Doing the same thing with forms is slightly more difficult and not
altogether desirable. In any case you wouldn't be able to update it as
there's nothing to indicate what to update in the constituent tables.

"John Baker" <Ba******@Veriz on.net> wrote in message
news:q4******** *************** *********@4ax.c om...

Hi:

While the crosstabs capability appears very powerful, I don't see how I can get the information into a form or anything else. Is there some way I can do a cross tabs, and then use the result? Whenever I try I find that there is no data available, unlike regular queries, forms and reports

Any help would be appreciated.

Regards

John Baker.

[MGFoster]

John Baker wrote:

Hi:

While the crosstabs capability appears very powerful, I don't see how I can get the
information into a form or anything else. Is there some way I can do a cross tabs, and
then use the result? Whenever I try I find that there is no data available, unlike regular
queries, forms and reports

Any help would be appreciated.

Regards

John Baker.

If you have Access 2002 & greater you can use the Pivot Table option
when creating a form using the Form design wizard.

--
MGFoster:::mgf
Oakland, CA (USA)