On the startup form of the attached mdb, select 1/12/2011 as begin date and 31/12/2011 as end date and select Portate on the option group and click the Grafico button.
Everything runs fine and the pivot chart is displayed.
How come if I modify the control source of the Testo122 text box in the frmPortate form from
=[p_tot]-[pm_rit]
to
=[p_tot]-nz([pm_rit])
and run the pivot chart again all the lines in the pivot chart disappear?
nz function throws a pivot chart
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
nz function throws a pivot chart
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: nz function throws a pivot chart
I'm using Access 2010 so I had to remove the Calendar control.
This is what I get when I click the Grafico button:
And if I change the control source to =[p_tot]-nz([pm_rit]):
This is what I get when I click the Grafico button:
And if I change the control source to =[p_tot]-nz([pm_rit]):
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Re: nz function throws a pivot chart
That's exactly what I'm aiming for! Well I use Access 2007 and the pivot chart throws a tantrum, could you please convert your file with the working pivot chart into Access 2007 and attach it to your reply or a new message? Thank you Hans :-)
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: nz function throws a pivot chart
Here you go.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Re: nz function throws a pivot chart
Thank you, I opened it in 2007 and all the pivot chart lines are missing(see picture), do you have a chance to try it out in 2007?
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: nz function throws a pivot chart
Sorry, no, I only have access to Access 2010, not to Access 2007.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12629
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: nz function throws a pivot chart
I just tried this using Access 2007 and the chart has no lines. I also tried it under Access 2010 and I get the same display as Hans.
StuartR
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: nz function throws a pivot chart
Thanks for testing, Stuart! Now we know that it's a problem of Access 2007, not of Giorgio's installation.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Re: nz function throws a pivot chart
Thanks Hans & Stuart, I suppose the "hotfix" is to move over to 2010 only that my company installed 2007 last April so it's going to be some time before that happens.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: nz function throws a pivot chart
I got the same problem in 2007 however if you change the query and put the nz in there it fixes the problem.
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Re: nz function throws a pivot chart
Thank you Pat, I hadn't considered it but you took care of that :-)