If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Number Error in Report - Display Zero
not
I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
#2
|
|||
|
|||
#Number Error in Report - Display Zero
Could you share the control source of the control that is displaying the
#Number error? Does this occur on every instance of the control or just some of them? I assume this is a calculation and all fields involved are numeric. -- Duane Hookom Microsoft Access MVP "Denise" wrote: not I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
#3
|
|||
|
|||
#Number Error in Report - Display Zero
This control source is for the Percentage where the #Number sign appears
=Sum([CountScore10])/([CountScore10 Grand Total Sum]) This is the control source for the Sum of the field. =Sum([CountScore10]) Does that help? Thanks. Denise -- Denise B. "Duane Hookom" wrote: Could you share the control source of the control that is displaying the #Number error? Does this occur on every instance of the control or just some of them? I assume this is a calculation and all fields involved are numeric. -- Duane Hookom Microsoft Access MVP "Denise" wrote: not I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
#4
|
|||
|
|||
#Number Error in Report - Display Zero
You probably need to check for division by zero:
=IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) -- Duane Hookom Microsoft Access MVP "Denise" wrote: This control source is for the Percentage where the #Number sign appears =Sum([CountScore10])/([CountScore10 Grand Total Sum]) This is the control source for the Sum of the field. =Sum([CountScore10]) Does that help? Thanks. Denise -- Denise B. "Duane Hookom" wrote: Could you share the control source of the control that is displaying the #Number error? Does this occur on every instance of the control or just some of them? I assume this is a calculation and all fields involved are numeric. -- Duane Hookom Microsoft Access MVP "Denise" wrote: not I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
#5
|
|||
|
|||
#Number Error in Report - Display Zero
Thnaks Duane. I'll give it a try.
-- Denise B. "Duane Hookom" wrote: You probably need to check for division by zero: =IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) -- Duane Hookom Microsoft Access MVP "Denise" wrote: This control source is for the Percentage where the #Number sign appears =Sum([CountScore10])/([CountScore10 Grand Total Sum]) This is the control source for the Sum of the field. =Sum([CountScore10]) Does that help? Thanks. Denise -- Denise B. "Duane Hookom" wrote: Could you share the control source of the control that is displaying the #Number error? Does this occur on every instance of the control or just some of them? I assume this is a calculation and all fields involved are numeric. -- Duane Hookom Microsoft Access MVP "Denise" wrote: not I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
#6
|
|||
|
|||
#Number Error in Report - Display Zero
Duane,
So do I type all of the below??? Are there any spaces?? I couldn't get it to work?? =IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) Thank you. -- Denise B. "Duane Hookom" wrote: You probably need to check for division by zero: =IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) -- Duane Hookom Microsoft Access MVP "Denise" wrote: This control source is for the Percentage where the #Number sign appears =Sum([CountScore10])/([CountScore10 Grand Total Sum]) This is the control source for the Sum of the field. =Sum([CountScore10]) Does that help? Thanks. Denise -- Denise B. "Duane Hookom" wrote: Could you share the control source of the control that is displaying the #Number error? Does this occur on every instance of the control or just some of them? I assume this is a calculation and all fields involved are numeric. -- Duane Hookom Microsoft Access MVP "Denise" wrote: not I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
#7
|
|||
|
|||
#Number Error in Report - Display Zero
This should all be on one line. I'm not sure about the logic of your
calculations or what you mean by "couldn't get it to work". -- Duane Hookom Microsoft Access MVP "Denise" wrote: Duane, So do I type all of the below??? Are there any spaces?? I couldn't get it to work?? =IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) Thank you. -- Denise B. "Duane Hookom" wrote: You probably need to check for division by zero: =IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) -- Duane Hookom Microsoft Access MVP "Denise" wrote: This control source is for the Percentage where the #Number sign appears =Sum([CountScore10])/([CountScore10 Grand Total Sum]) This is the control source for the Sum of the field. =Sum([CountScore10]) Does that help? Thanks. Denise -- Denise B. "Duane Hookom" wrote: Could you share the control source of the control that is displaying the #Number error? Does this occur on every instance of the control or just some of them? I assume this is a calculation and all fields involved are numeric. -- Duane Hookom Microsoft Access MVP "Denise" wrote: not I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
#8
|
|||
|
|||
#Number Error in Report - Display Zero
Thanks Duane.
I did get it to work. Thanks. -- Denise B. "Duane Hookom" wrote: This should all be on one line. I'm not sure about the logic of your calculations or what you mean by "couldn't get it to work". -- Duane Hookom Microsoft Access MVP "Denise" wrote: Duane, So do I type all of the below??? Are there any spaces?? I couldn't get it to work?? =IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) Thank you. -- Denise B. "Duane Hookom" wrote: You probably need to check for division by zero: =IIf(Nz([CountScore10 Grand Total Sum],0)=0,0, Sum([CountScore10])/[CountScore10 Grand Total Sum]) -- Duane Hookom Microsoft Access MVP "Denise" wrote: This control source is for the Percentage where the #Number sign appears =Sum([CountScore10])/([CountScore10 Grand Total Sum]) This is the control source for the Sum of the field. =Sum([CountScore10]) Does that help? Thanks. Denise -- Denise B. "Duane Hookom" wrote: Could you share the control source of the control that is displaying the #Number error? Does this occur on every instance of the control or just some of them? I assume this is a calculation and all fields involved are numeric. -- Duane Hookom Microsoft Access MVP "Denise" wrote: not I created my report by using the summary options. When the numbers print out, I get a #Number error in the percentage field. If I change the number format, it would be a percentage. The answer is "0" but comes up #Number?? What should I do. -- Denise B. |
Thread Tools | |
Display Modes | |
|
|