467,881 Members | 1,218 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,881 developers. It's quick & easy.

MS Access Pivotchart code

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
  • viewed: 1824
Share:
1 Reply
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.

Similar topics

reply views Thread by Tracy Griever via AccessMonster.com | last post: by
1 post views Thread by windandwaves | last post: by
reply views Thread by francophone77 | last post: by
reply views Thread by guaj1818 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.