|
| 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
August 12th, 2009, 01:26 PM
posted to microsoft.public.access.reports
|
|||
|
|||
#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
August 12th, 2009, 05:06 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#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
August 12th, 2009, 05:55 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#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
August 12th, 2009, 06:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#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
August 12th, 2009, 07:43 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#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
August 12th, 2009, 07:55 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#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
August 12th, 2009, 09:36 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#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
August 13th, 2009, 12:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
#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 | |
|
|
Linear Mode
