something like crosstab query in Access .adp

[Guest]

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.

 

[Larry Linson]

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

 

[Duane Hookom]

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

 

[Guest]

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