Calculated Field in Form

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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.
 
The above referenced are fields in the form.
Use the orignal calculations instead of the form text box names in the
calculation.
 
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 said:
Use the orignal calculations instead of the form text box names in the
calculation.

--
Build a little, test a little.


Cathy said:
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.
Click to expand...
Click to expand...
 
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 said:
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 said:
The above referenced are fields in the form.
Click to expand...
Use the orignal calculations instead of the form text box names in the
calculation.

--
Build a little, test a little.


Cathy said:
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.
Click to expand...
Click to expand...
Click to expand...
 
2009 Total Participants (July) and 2009 EE are not calculated fields -
instead it is straight data.

KARL DEWEY said:
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 said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.
 
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 said:
2009 Total Participants (July) and 2009 EE are not calculated fields -
instead it is straight data.

KARL DEWEY said:
I tried adjusting the expression to read from the query, not the form -
Click to expand...
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top