[AccessD] Access pivot tables

Ok Darryl, thanks for the advice.

Andy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: 19 August 2010 01:48
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access pivot tables



____________________________________________________________________________
___________

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



IMHO you should use the best tool for the job. That tool would be Excel.
Excel's pivot table capabilities far exceed what Access can do and are much
more flexible and powerful.  You can either export the recordset to Excel
and create the PT or Excel will also let you hook a PT into many external
datasources, including Access.

Personally I would avoid PT's and charts in Access.  Your milage may vary...

cheers
Darryl.

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, 18 August 2010 6:53 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access pivot tables

Hi all

I may have just missed it but I don't recall anyone discussing these on the
list. Anyway I've never used them but am in the position that a user has
started to construct an Access db and has created one and now needs help and
advice. Anyone know anything about them? Are they any good? Do they expose a
full set of methods and properties? Should they be avoided at all costs? Or
what? Who knows? Help!

Andy


-- 
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.
____________________________________________________________________________
___________

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