Connecting Tech Pros Worldwide Forums | Help | Site Map

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

John Baker
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

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


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" <Baker.JH@Verizon.net> wrote in message
news:q41krv4m4omnks6ohq2t175phfaa8s7f15@4ax.com...[color=blue]
> Hi:
>
> While the crosstabs capability appears very powerful, I don't see how I[/color]
can get the[color=blue]
> information into a form or anything else. Is there some way I can do a[/color]
cross tabs, and[color=blue]
> then use the result? Whenever I try I find that there is no data[/color]
available, unlike regular[color=blue]
> queries, forms and reports
>
> Any help would be appreciated.
>
> Regards
>
> John Baker.[/color]


MGFoster
Guest
 
Posts: n/a
#3: Nov 12 '05

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


John Baker wrote:
[color=blue]
> 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.[/color]

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)

Closed Thread