something like crosstab query in Access .adp

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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
 
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
 
Back
Top