computed report field

  • Thread starter Thread starter thriveni
  • Start date Start date
T

thriveni

I have a report that is based on a Table recordsource. In
the detail section, i am trying to divide one of the
numeric fields(which is a field of the table) using the
expression builder and the display is always an #error on
the report. why does it not accept my expression ?
Any help would be helpful !
 
Suggestions:

1. The expression in the Control Source of your text box must start with an
equal sign, e.g.:
=[SomeField] / [AnotherField]

2. Both fields must be of type Number (if you open the table in design
view).

3. The divisor cannot be zero (i.e. dividing by zero gives an error).

4. The Name of this text box cannot be the same as the name of a field in
the report's recordsource.

5. Make sure the text box is in the right section of the report. Avoid the
page header/footer if possible.

6. Sometimes, adding both fields to the report solves the problem. You can
set their Visible property to No so they don't show.
 
Thanku very much for your help.
I had the computed field the same name as the field name
of the recordsource. Once I changed it, everything worked
great.
-----Original Message-----
Suggestions:

1. The expression in the Control Source of your text box must start with an
equal sign, e.g.:
=[SomeField] / [AnotherField]

2. Both fields must be of type Number (if you open the table in design
view).

3. The divisor cannot be zero (i.e. dividing by zero gives an error).

4. The Name of this text box cannot be the same as the name of a field in
the report's recordsource.

5. Make sure the text box is in the right section of the report. Avoid the
page header/footer if possible.

6. Sometimes, adding both fields to the report solves the problem. You can
set their Visible property to No so they don't show.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
I have a report that is based on a Table recordsource. In
the detail section, i am trying to divide one of the
numeric fields(which is a field of the table) using the
expression builder and the display is always an #error on
the report. why does it not accept my expression ?
Any help would be helpful !
Click to expand...


.
Click to expand...
 
Back
Top