A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

access 2003 pivot view



 
 
Thread Tools Display Modes
  #11  
Old August 22nd, 2005, 02:38 PM
SaveTheMonarchButterflies
external usenet poster
 
Posts: n/a
Default

I'm testing the Access PT view because of an article in a journal we
subscribe to, which claims there are several advantages over Excel's PT. So
far I like the fact that you can set up the data in a more pivot friendly
fashion by creating a query, then running the PT right on the query results.
(You can also run it on tables and bound forms.) It saves the last setup you
made, which turns out to be a good thing unless you don't like the last thing
you did. There is no undo. The article also claims there is more extensive
drill down into the data, which I haven't tinkered with yet.
The article also referred to a bug which is fixed in Office XP Service Pack
1. Since I have SP1 I didn't look up the bug.

If you decide to give it a try let me know what you think!
Thanks for letting me think at you about this. The rounding error isn't
completely fixed by changing the field size in the data type, but is greatly
diminished. I hope I can make a discovery that takes it the rest of the way.

I use crosstabs quite a bit. When I need to use pivot tables, I open Excel
and link to my Access/SQL Server tables/queries.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Design View problem Access 2003 Alex Using Forms 1 June 22nd, 2005 09:55 PM
Why is Pivot Table View is not showing up in Access 2003? AndrewWTaylor General Discussion 0 June 1st, 2005 12:11 AM
is Access 2003 any better than XP? Gorb General Discussion 4 November 11th, 2004 09:44 PM
is Access 2003 any better than XP? Gorb Using Forms 2 November 11th, 2004 09:20 AM
Productkey problem when installing office 2003 on network Stefan Schreurs Setup, Installing & Configuration 1 June 1st, 2004 11:16 PM


All times are GMT +1. The time now is 06:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.