something like crosstab query in Access .adp

I need to create a report using something like the
crosstab query except I am using A2K .adp and there is no
cross tab query. I need a report with columns similar to
an excel page.

wrote

I need to create a report using something like the
crosstab query except I am using A2K .adp and there is no
cross tab query. I need a report with columns similar to
an excel page.

There's something _like_ a crosstab, pivot table view and pivot chart view,
but only in Access 2002 and 2003. I haven't used pivot table view in an ADP,
but AFAIK, it applies there as well as in MDB.

While it may be "easier suggested than done", perhaps it is time to upgrade
to a newer version. (Access 2000 is now out of support, too.)

Larry Linson
Microsoft Access MVP

You might want to consider this third party tool
http://www.rac4sql.net/rac_sql2k_main.asp.

--
Duane Hookom
MS Access MVP


wrote in message
...
I need to create a report using something like the
crosstab query except I am using A2K .adp and there is no
cross tab query. I need a report with columns similar to
an excel page.

Sorry it is Access 2003 I am using (typo). I am trying to
use the pivot tables but I am not finding them very user
friendly but I'll keep hacking away a at it. Calculations
are the biggest problem.Thanks
-----Original Message-----

wrote

I need to create a report using something like the
crosstab query except I am using A2K .adp and there is
no
cross tab query. I need a report with columns similar
to
an excel page.

There's something _like_ a crosstab, pivot table view
and pivot chart view,
but only in Access 2002 and 2003. I haven't used pivot
table view in an ADP,
but AFAIK, it applies there as well as in MDB.

While it may be "easier suggested than done", perhaps it
is time to upgrade
to a newer version. (Access 2000 is now out of support,
too.)

Larry Linson
Microsoft Access MVP


.