Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 09-15-2016, 11:02 PM   #1
Newly Registered User
Join Date: Sep 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Fijian is on a distinguished road
Access2013 Pivot Table - Use in a query/table

I have done the hard part - created a Form Pivot Table in Access 2013 from an OLAP Cube using properties - ConnectionString and DataMember. The PivotTable works fine and gives me the result I want.
But I am stuck with the easy part - I want to use the result in a Query or Table (i.e. The totals it is showing in the pivot table.
How can I do this? I am a bit stuck as I am not sure if it is an SQL, select using Form parameters or PassThrough query.
Any suggestions will be much appreciated.

Fijian is offline   Reply With Quote

access 2013 , form , pivot form data , pivot table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table/Query Cowboy_BeBa Queries 4 02-14-2015 09:05 AM
How to calculate number of workdays in access2013 query ESAKKI109 Queries 1 08-12-2014 05:55 AM
Pivot table + query equaliser Queries 2 10-17-2007 03:37 AM
Pivot table from query philea_92 General 0 06-20-2007 02:48 AM
Pivot Table Query Gremlin76 Queries 0 12-27-2001 12:25 PM

All times are GMT -8. The time now is 07:21 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World