[AccessD] Pivot Tables

Darryl Collins Darryl.Collins at iag.com.au
Sun Apr 3 20:02:54 CDT 2011


_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



Pivot tables in Access are so insipid and fiddly that almost anyone who needs to use PTs seriously end up using Excel anyway, and either hooks Excel into the database or pushes the source out of the database into an Excel workbook / template which then automatically produces the PT using code.  Best of both world then.  Excel's PT ability is far superior to what is native in Access.

My advice would be that using Excel is still the better approach.  Of course your milage may vary depending on what you want to do.

Regards
Darryl.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Saturday, 2 April 2011 8:32 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Pivot Tables

Hey All
I have been fooling around with Pivot Tables, got everythng working. 
But........
After many hours of research, I have not experienced a more convulted 
description of how to programatically do things with ACCESSand Pivot 
Tables, properties, objects etc. when dealing with the Pivot Table. I 
can find tons of EXCEL examples but when you try out the examples they 
do not work in ACCESS. It is like MS said "Here you go, here is a new 
feature, but don't bother us, if you run into problems". If anyone has a 
good source of information for Pivot Tables and ACCESS (programming with 
VBA) could you please let me know.

 Thanks Kindly.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________




More information about the AccessD mailing list