I have just upgraded from Access 97 to Access 2003. In Access 97, creating pivot tables could be done by using the Form's pivot table wizard. Once created,...

I have not done much in pivot tables. But I have designed a pivot table form that does all I need except for the last step - creating a column to show a...

i am using pivot table. in access 2002 forms. i want that expand button feature is unavailable...is that possible. moreover user shd not be allowd to right...

I have a Pivot Table based on a linked query from SQL Server 2000 that does not sum decimals correctly. The query displays values with decimals correctly, but...

I've created a pivot table from a query. The data numbers are displayed, however, I cannot drilldown to the underlying names that corresponds to the numbers. ...

Access 2000 WinXP. I have created a pivot table with a list of results that I want to display. The form only shows part of the data - I can change the width of...

i have access 2007 and have created a pivot table form. it works fine for me. the users are using access runtime and when they go to open the form, it...

I have a pivot table form based on a query the data contains names and course dates in the following format Course Gas Check...

I've successfully created a pivot table form using a select query. Now I want to add a Title, page numbers and form footer. On the design page Access allows...

I have a pivot table that shows sum of charges and count of charges. I would like for that data to be stacked not aligned side by side. I know that I have...

I'm using an adp access 2007. How can I format the number to2,000,000 (without decimals and with comma for thousands)? Thanks for any suggestion JCP

New to PTs in Access. Got most of what I want, but I want to make the column headers deeper rather than wider, and word-wrap. I can't seem to accomplish...

I made a form in access with the pivot table wizard. The form looks and works great and I "data refresh" to change the pivot table with the drop downs. ...

I am having trouble with several PivotTables that I have created. The drop down boxes for all headings will show the different options but I cannot change...

How do I have a macro populate the drop fields from the field list and do the sum/count, in a pivot table? I have users that just want to see end result, each...

i have pivots table in different Projects which were running correctly, suddenly all of them stoped running correctly and display this message "The query could...

Hi, I have forms which display in PivotTable view. One column is a percentage of the row total. I have set the number format in the properties sheet to...

The pivot tables' command on the switchboard opens the pivot table as form view, not as pivot table view, even though the pivot table's properties are set to...

Hi, I have a pivot table which displays some handy statistics on my database. I have linked this table to a button on a form which opens the pivot table. The...

You might have seen this msg from Ben but no one replied yet. I have the exact same problem. Can anyone help with this? Thank you as always. Hi, I have a...