By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

MS Access Pivotchart code

P: 5
I have a pivotchart in a tab in my main form. First question: Is there a way to display only a certain number of the most recent records? For example, to limit the pivotchart to displaying only the 20 most recent values. The values have both a time and ID tag on them if that helps.

For my second question: Is there a way to automatically update the pivot chart as the query is also updated? When I enter data into a form in one of my tabs, I'd like the pivotcharts to also update at the same time. Currently, I have to close and re-open the form to update the pivotcharts.

Thanks
Nov 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: 15
I have a pivotchart in a tab in my main form. First question: Is there a way to display only a certain number of the most recent records? For example, to limit the pivotchart to displaying only the 20 most recent values. The values have both a time and ID tag on them if that helps.

For my second question: Is there a way to automatically update the pivot chart as the query is also updated? When I enter data into a form in one of my tabs, I'd like the pivotcharts to also update at the same time. Currently, I have to close and re-open the form to update the pivotcharts.

Thanks

Frankly speaking I don't know if it works for pivot chart, but works for chart:
1) Design view, double click on the chart
2) right button click--> properties
3) Data folder, Row Source
SELECT TOP n instruction.

Bea
Oct 29 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.