Unwanted Parameter Prompts?

[Nick CWT]

I'm using the following expression in a text box on a report footer. When I
go to view report I'm getting Parameter prompts for Total JR CG1,3,2,and 4?
I'm used to seeing Parameter prompts for querys, so I'm stumped. I
appreciate any help. Thanks.

=Sum([Total JR CG1]+[Total JR CG3]+[Total JR CG2]+[Total JR CG4])

 

[Ofer Cohen]

Are the fields specified in the Sum are fields in the RecordSourec of the
report?

If they are not, then it will prompt for a field name.

 

[Roger Carlson]

If [Total JR CG1] is an alias for another Sum function, it won't recognize
it as a field. You'd have to put the actual expression in the Sum instead
of the alias.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Nick CWT]

That worked, however that same expression is now giving me a nullvalue?
There are values in the fields being added but the field with that expression
is blank in the report? I appreciate any help you can give. Thanks.

Are the fields specified in the Sum are fields in the RecordSourec of the
report?

If they are not, then it will prompt for a field name.

--
Good Luck
BS"D

I'm using the following expression in a text box on a report footer. When I
go to view report I'm getting Parameter prompts for Total JR CG1,3,2,and 4?
I'm used to seeing Parameter prompts for querys, so I'm stumped. I
appreciate any help. Thanks.

=Sum([Total JR CG1]+[Total JR CG3]+[Total JR CG2]+[Total JR CG4])

 

[Ofer Cohen]

Use the Nz function to replace Null with 0

Sum(Nz([Total JR CG1],0)+Nz([Total JR CG3],0)+Nz([Total JR CG2],0)+Nz([Total
JR CG4],0))

But with the real field name
--
Good Luck
BS"D

That worked, however that same expression is now giving me a nullvalue?
There are values in the fields being added but the field with that expression
is blank in the report? I appreciate any help you can give. Thanks.

Are the fields specified in the Sum are fields in the RecordSourec of the
report?

If they are not, then it will prompt for a field name.

--
Good Luck
BS"D

I'm using the following expression in a text box on a report footer. When I
go to view report I'm getting Parameter prompts for Total JR CG1,3,2,and 4?
I'm used to seeing Parameter prompts for querys, so I'm stumped. I
appreciate any help. Thanks.

=Sum([Total JR CG1]+[Total JR CG3]+[Total JR CG2]+[Total JR CG4])

 

[Nick CWT]

Thanks Ofer. It got me on the right track and solved the problem. Peace.

Use the Nz function to replace Null with 0

Sum(Nz([Total JR CG1],0)+Nz([Total JR CG3],0)+Nz([Total JR CG2],0)+Nz([Total
JR CG4],0))

But with the real field name
--
Good Luck
BS"D

That worked, however that same expression is now giving me a nullvalue?
There are values in the fields being added but the field with that expression
is blank in the report? I appreciate any help you can give. Thanks.

Are the fields specified in the Sum are fields in the RecordSourec of the
report?

If they are not, then it will prompt for a field name.

--
Good Luck
BS"D


:

I'm using the following expression in a text box on a report footer. When I
go to view report I'm getting Parameter prompts for Total JR CG1,3,2,and 4?
I'm used to seeing Parameter prompts for querys, so I'm stumped. I
appreciate any help. Thanks.

=Sum([Total JR CG1]+[Total JR CG3]+[Total JR CG2]+[Total JR CG4])