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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 | |
|
|
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 |