ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PIVOT TABLE FROM A FORM IN ACCESS (https://www.excelbanter.com/excel-discussion-misc-queries/94802-pivot-table-form-access.html)

nazzoli

PIVOT TABLE FROM A FORM IN ACCESS
 
Is it possible to create a pivot table from a form in Access? The reason I
need to use the form is because I need one of the formulas that is in the
form? If yes please send me the steps.

Thanks.

nazzoli

wjohnson

PIVOT TABLE FROM A FORM IN ACCESS
 

My only selections are "create a pivot table" from a table or query.
In Access you use a "blank" form to create the pivot table from a table
or query.
Can you use a query to create your calculated field?
My Access is 2000 - and the answer to your question - seems to be NO.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=553363


wjohnson

PIVOT TABLE FROM A FORM IN ACCESS
 

My only selections are "create a pivot table" from a table or query.
In Access you use a "blank" form to create the pivot table from a table
or query.
Can you use a query to create your calculated field?
My Access is 2000 - and the answer to your question - seems to be NO.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=553363



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com