Won't Compute

  • Thread starter Thread starter bhipwell via AccessMonster.com
  • Start date Start date
B

bhipwell via AccessMonster.com

A seemingly simple formula is giving me an #Error message. Here's the info.

1) The field on the report uses information from a query field named Dent1.
When the query is run by itself, the value it provides is 11.45.

2) When I create a field box in the report with only "=Dent1", the report
will display "11.45"

3) When I create a field box with the fomula:
=IIf([Forms]![FormA]![Class] = "Class 1", "Yes", "No")
the report displays "Yes" assuming Class 1 is selected

Now...

4) When I create a field box with the formula:
"=IIf([Forms]![FormA]![Class] = "Class 1", [Dent1], "No")"
the report displays "#Error" assuming Class 1 is selected

What gives?

B
 
bhipwell said:
A seemingly simple formula is giving me an #Error message. Here's the info.

1) The field on the report uses information from a query field named Dent1.
When the query is run by itself, the value it provides is 11.45.

2) When I create a field box in the report with only "=Dent1", the report
will display "11.45"

3) When I create a field box with the fomula:
=IIf([Forms]![FormA]![Class] = "Class 1", "Yes", "No")
the report displays "Yes" assuming Class 1 is selected

Now...

4) When I create a field box with the formula:
"=IIf([Forms]![FormA]![Class] = "Class 1", [Dent1], "No")"
the report displays "#Error" assuming Class 1 is selected
Click to expand...


Make sure the name of the text box is NOT Dent1
 
I should know better. Although not an expert, I can get around Access quite
well. I may have only run into this once in the past and it didn't even
cross my mind. THANK YOU for allowing me to keep an extra few hairs on my
head.

THANKS!

B
 
Back
Top