#Number Error in Report - Display Zero

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

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.
 
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.
 
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
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
Thnaks Duane. I'll give it a try.
--
Denise B.


Duane Hookom said:
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 said:
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 said:
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


:

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.
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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


:

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.
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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.


:

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


:

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.
Click to expand...
Click to expand...
Click to expand...
 
Thanks Duane.

I did get it to work.

Thanks.
--
Denise B.


Duane Hookom said:
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 said:
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 said:
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


:

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.


:

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


:

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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top