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
|
|||
|
|||
Unwanted Parameter Prompts?
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]) |
#2
|
|||
|
|||
Unwanted Parameter Prompts?
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 "Nick CWT" wrote: 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]) |
#3
|
|||
|
|||
Unwanted Parameter Prompts?
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/...UBED1=ACCESS-L "Nick CWT" wrote in message ... 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]) |
#4
|
|||
|
|||
Unwanted Parameter Prompts?
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. "Ofer Cohen" wrote: 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 "Nick CWT" wrote: 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]) |
#5
|
|||
|
|||
Unwanted Parameter Prompts?
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 "Nick CWT" wrote: 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. "Ofer Cohen" wrote: 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 "Nick CWT" wrote: 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]) |
#6
|
|||
|
|||
Unwanted Parameter Prompts?
Thanks Ofer. It got me on the right track and solved the problem. Peace.
"Ofer Cohen" wrote: 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 "Nick CWT" wrote: 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. "Ofer Cohen" wrote: 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 "Nick CWT" wrote: 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]) |
Thread Tools | |
Display Modes | |
|
|