Calculated Field in Form

[Cathy]

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.

 

[KARL DEWEY]

The above referenced are fields in the form.
Use the orignal calculations instead of the form text box names in the
calculation.

 

[Cathy]

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.

Use the orignal calculations instead of the form text box names in the
calculation.

--
Build a little, test a little.

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.

 

[KARL DEWEY]

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.

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.

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.

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.

 

[Cathy]

2009 Total Participants (July) and 2009 EE are not calculated fields -
instead it is straight data.

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.

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.

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.


:

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.

 

[Jeff Boyce]

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.

 

[KARL DEWEY]

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.

2009 Total Participants (July) and 2009 EE are not calculated fields -
instead it is straight data.

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.

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.

:

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.


:

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.