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
|
|||
|
|||
Calculated Field in Form
I have a calculated field in a form (that was working & now it's not). The
formula is as follows: =[2009 TOTAL Participants (July)]/[2009 EE] The above referenced are fields in the form. The formula is located in the Control Source, Default Value, Before Update and After Update locations. It is set to percent with 2 decimal places. I receive a #Name? error. Any help is appreciated. Thanks. |
#2
|
|||
|
|||
Calculated Field in Form
The above referenced are fields in the form.
Use the orignal calculations instead of the form text box names in the calculation. -- Build a little, test a little. "Cathy" wrote: I have a calculated field in a form (that was working & now it's not). The formula is as follows: =[2009 TOTAL Participants (July)]/[2009 EE] The above referenced are fields in the form. The formula is located in the Control Source, Default Value, Before Update and After Update locations. It is set to percent with 2 decimal places. I receive a #Name? error. Any help is appreciated. Thanks. |
#3
|
|||
|
|||
Calculated Field in Form
The odd thing is....it worked at one point. Not sure what happened to cause
the change. I tried adjusting the expression to read from the query, not the form - however it didn't work. "KARL DEWEY" wrote: The above referenced are fields in the form. Use the orignal calculations instead of the form text box names in the calculation. -- Build a little, test a little. "Cathy" wrote: I have a calculated field in a form (that was working & now it's not). The formula is as follows: =[2009 TOTAL Participants (July)]/[2009 EE] The above referenced are fields in the form. The formula is located in the Control Source, Default Value, Before Update and After Update locations. It is set to percent with 2 decimal places. I receive a #Name? error. Any help is appreciated. Thanks. |
#4
|
|||
|
|||
Calculated Field in Form
I tried adjusting the expression to read from the query, not the form -
however it didn't work. What was the results? What is your formula for [2009 TOTAL Participants (July)] and for [2009 EE] ? -- Build a little, test a little. "Cathy" wrote: The odd thing is....it worked at one point. Not sure what happened to cause the change. I tried adjusting the expression to read from the query, not the form - however it didn't work. "KARL DEWEY" wrote: The above referenced are fields in the form. Use the orignal calculations instead of the form text box names in the calculation. -- Build a little, test a little. "Cathy" wrote: I have a calculated field in a form (that was working & now it's not). The formula is as follows: =[2009 TOTAL Participants (July)]/[2009 EE] The above referenced are fields in the form. The formula is located in the Control Source, Default Value, Before Update and After Update locations. It is set to percent with 2 decimal places. I receive a #Name? error. Any help is appreciated. Thanks. |
#5
|
|||
|
|||
Calculated Field in Form
2009 Total Participants (July) and 2009 EE are not calculated fields -
instead it is straight data. "KARL DEWEY" wrote: I tried adjusting the expression to read from the query, not the form - however it didn't work. What was the results? What is your formula for [2009 TOTAL Participants (July)] and for [2009 EE] ? -- Build a little, test a little. "Cathy" wrote: The odd thing is....it worked at one point. Not sure what happened to cause the change. I tried adjusting the expression to read from the query, not the form - however it didn't work. "KARL DEWEY" wrote: The above referenced are fields in the form. Use the orignal calculations instead of the form text box names in the calculation. -- Build a little, test a little. "Cathy" wrote: I have a calculated field in a form (that was working & now it's not). The formula is as follows: =[2009 TOTAL Participants (July)]/[2009 EE] The above referenced are fields in the form. The formula is located in the Control Source, Default Value, Before Update and After Update locations. It is set to percent with 2 decimal places. I receive a #Name? error. Any help is appreciated. Thanks. |
#6
|
|||
|
|||
Calculated Field in Form
Already responded to in another newsgroup.
By posting the same question in more than one newsgroup, you give yourself more work (checking all the places you posted), and you give us more work (we volunteer our time here, so the time spent solving an issue someone else already has solved is time we don't have to help someone else...) Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Cathy" wrote in message news I have a calculated field in a form (that was working & now it's not). The formula is as follows: =[2009 TOTAL Participants (July)]/[2009 EE] The above referenced are fields in the form. The formula is located in the Control Source, Default Value, Before Update and After Update locations. It is set to percent with 2 decimal places. I receive a #Name? error. Any help is appreciated. Thanks. |
#7
|
|||
|
|||
Calculated Field in Form
Are [2009 TOTAL Participants (July)] and [2009 EE] names of fields in your
table? Or they labels applied in the form? -- Build a little, test a little. "Cathy" wrote: 2009 Total Participants (July) and 2009 EE are not calculated fields - instead it is straight data. "KARL DEWEY" wrote: I tried adjusting the expression to read from the query, not the form - however it didn't work. What was the results? What is your formula for [2009 TOTAL Participants (July)] and for [2009 EE] ? -- Build a little, test a little. "Cathy" wrote: The odd thing is....it worked at one point. Not sure what happened to cause the change. I tried adjusting the expression to read from the query, not the form - however it didn't work. "KARL DEWEY" wrote: The above referenced are fields in the form. Use the orignal calculations instead of the form text box names in the calculation. -- Build a little, test a little. "Cathy" wrote: I have a calculated field in a form (that was working & now it's not). The formula is as follows: =[2009 TOTAL Participants (July)]/[2009 EE] The above referenced are fields in the form. The formula is located in the Control Source, Default Value, Before Update and After Update locations. It is set to percent with 2 decimal places. I receive a #Name? error. Any help is appreciated. Thanks. |
Thread Tools | |
Display Modes | |
|
|