Access 2013

[Lightwave]

Access 2013 deprecating Pivot Table - Is MS for real?

I had a look at some of the deprecated features in Access 2013 and one of the items that it says is deprecated is Pivot tables??? - with the comment better pivot in excel (huh!!)

It's not clear from the entry are they talking about web / sharepoint only or are they talking about desktop..

see here

http://technet.microsoft.com/en-us/library/cc178954(v=office.15).aspx

This really would be a total end to my systems in Access 2013.
I'd effectively be kept in 2010 or I'd have to move to a new platform.

mind numbingly stupid or what.

I'll delete this if I've got this wrong but just seeking clarification

 

[DJkarl]

I believe your interpretation is correct, I think Bob Larson had a post about Access 2013 in here, and his experience with it was not a great one. They are really pushing it to sharepoint/web development.

 

[Lightwave]

Holy Toledo that really is shooting themselves in the foot. Had it confirmed by an MVP as well. I'm pretty stunned as it really will have major implications.

Particularly for the really rich reporting tool based on pivot tables. I understand there will be workarounds to get into excel but then getting reports out of excel will be a right pain in the a****.

Will probably be able to exist on 2010 for ages before then though.

 

[Lightwave]

Follow up question -- Is there going to be an Access 2013 Run Time version?

By requiring links to excel for pivoting and or activex, distribution of self-contained desktop systems with pivots included its going to be that much harder that it suggests MS consider it a low priority to facilitate. Clearly again they wish people to distribute systems via sharepoint.

 

[Lightwave]

I found out it is assumed there will be an Access 2013 run time version.

 

[boblarson]

Yeah, 2013 is one reason why I am livid with MS. That and Windows 8.

 

[bob fitz]

Yeah, 2013 is one reason why I am livid with MS. That and Windows 8.

What's wrong with Windows 8 Bob?

 

[boblarson]

What's wrong with Windows 8 Bob?

Sucks. Interface sucks, looks horrible. Can't stand it. I tried it and, while I have been an early adopter of almost all Windows versions, and have liked them, I can't stand this one.

 

[bob fitz]

Sucks. Interface sucks, looks horrible. Can't stand it. I tried it and, while I have been an early adopter of almost all Windows versions, and have liked them, I can't stand this one.

Glad to say that I have no experience with it but sounds as though only a sucker will like it.

 

[boblarson]

Glad to say that I have no experience with it but sounds as though only a sucker will like it.

 

[Simon_MT]

Lightwave,

Many years ago I got really annoyed with Pivot Tables they were so slow to modify so I made my own using Group By and Expessions using totalling Sum. It may not be elegant but you maybe be able to see daylight from the hole Microsoft dug for you.

I used this to create a Debtors Trial Balance Ageing.

Simon

 

[Lightwave]

Thanks Simon I suspect that as they are stand alone systems it will be easier to keep them in the access versions to the end of their lives and that going forward I will either not give pivots to users or alternatively create my own using a version of select. Who knows they might reimplement pivots in the next incarnation.

 

[hket_29]

just got to go around in the query to make a pivot table like report

this is my sql view of my query
SELECT Sales_Item.Chinese_Name, "From " & [Forms]![Item_Compare_Report]![1st_Period_Start_Day] & " to " & [Forms]![Item_Compare_Report]![1st_Period_End_Day] AS text1, Sum(IIf([Sales_Order]![date] Between [Forms]![Item_Compare_Report]![1st_Period_Start_Day] And [Forms]![Item_Compare_Report]![1st_Period_End_Day],[Sales_Order_Subform]![Subtotal],0)) AS [Period 1], IIf([Forms]![Item_Compare_Report]![4th_Period_Start_Day]<>"","From " & [Forms]![Item_Compare_Report]![4th_Period_Start_Day] & " to " & [Forms]![Item_Compare_Report]![4th_Period_End_Day],"") AS text2, IIf([Forms]![Item_Compare_Report]![4th_Period_Start_Day]<>"",FormatCurrency(Sum(IIf([Sales_Order]![date] Between [Forms]![Item_Compare_Report]![4th_Period_Start_Day] And [Forms]![Item_Compare_Report]![4th_Period_End_Day],[Sales_Order_Subform]![Subtotal],0))),"") AS [Period 2], IIf([Forms]![Item_Compare_Report]![3rd_Period_Start_Day]<>"","From " & [Forms]![Item_Compare_Report]![3rd_Period_Start_Day] & " to " & [Forms]![Item_Compare_Report]![3rd_Period_End_Day],"") AS text3, IIf([Forms]![Item_Compare_Report]![3rd_Period_Start_Day]<>"",FormatCurrency(Sum(IIf([Sales_Order]![date] Between [Forms]![Item_Compare_Report]![3rd_Period_Start_Day] And [Forms]![Item_Compare_Report]![3rd_Period_End_Day],[Sales_Order_Subform]![Subtotal],0))),"") AS [Period 3]
FROM Sales_Order INNER JOIN (Sales_Item INNER JOIN Sales_Order_Subform ON Sales_Item.Barcode = Sales_Order_Subform.Barcode) ON (Sales_Order.Invoice_Number = Sales_Order_Subform.Invoice_Number) AND (Sales_Order.Location_ID = Sales_Order_Subform.Location_ID)
GROUP BY Sales_Item.Chinese_Name, "From " & [Forms]![Item_Compare_Report]![1st_Period_Start_Day] & " to " & [Forms]![Item_Compare_Report]![1st_Period_End_Day], IIf([Forms]![Item_Compare_Report]![4th_Period_Start_Day]<>"","From " & [Forms]![Item_Compare_Report]![4th_Period_Start_Day] & " to " & [Forms]![Item_Compare_Report]![4th_Period_End_Day],""), IIf([Forms]![Item_Compare_Report]![3rd_Period_Start_Day]<>"","From " & [Forms]![Item_Compare_Report]![3rd_Period_Start_Day] & " to " & [Forms]![Item_Compare_Report]![3rd_Period_End_Day],"");

 

[RustyRick]

If building an app for web usages isn't so good. How does sending email forms to customers and inputting their responses work?

 

[RustyRick]

Or what about these add on's like "Opengate" advertised on this web site?