Thanks JerryKlmns
You raise some valid questions. The pivot table gets its data from an access table. I tried using queries but found it too much to try and get the data to look like the pivot table in the form.
After sepending a whole day yesterday trying to find the answer, I finally got...
I have an embedded pivot table in an access form that needs to be refreshed. I created an event procedure to open the Pivot Table in excel when the form is opened. I have a macro in the excel workbook that that I manually run that refeshes the table and then closes the workbook.
Is there a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.