expression issues on totals

[Linda]

I've checked out the prior messages regarding the error message that appears
when attempting to run a report (The expression is typed incorrectly, or is
too complicated to be evaluated......).

The query i based the report on runs fine. The report, Land Record report,
does not. The only fields that I could forsee having any issues are
numerical fields where I have subtotals and totals. The subtotals are
grouped by Segment (yes, such a field). This is an example of the language -
=Sum([State Amount]) Again, state amount is a field. I have the same
language for the totals, except that it is in the report footer grouped by
Grant Number.

Could there be an issue with using the same language, even though in
different parts of the report? I can't understand why this isn't working.

Linda

 

[Klatuu]

([State Amount]) must be a field in the report's record source. It cannot be
the name of a control on the report.

That being said, however, it is always best, when you are asking about an
error to include the error number and description, and point out the line of
code where the errror occurs, if it is in code.

 

[Linda]

You must have missed the line where I did say that State Amount is a field.
The message I am receiving doesn't have a number, just a statement, when I
attempt to run the report. FIrst the parameters appear, which I fill in,
then comes this lovely message: "This expression is typed incorrectly, or it
is too complex to be evaluated. For example, a numeric expression may
contain too many complicated elements.. Try simplifying the expression by
assigning parts of the expression to variables." I see that others have
received this message, but that there really isn't a simple resolution.


Linda

([State Amount]) must be a field in the report's record source. It cannot be
the name of a control on the report.

That being said, however, it is always best, when you are asking about an
error to include the error number and description, and point out the line of
code where the errror occurs, if it is in code.
--
Dave Hargis, Microsoft Access MVP

I've checked out the prior messages regarding the error message that appears
when attempting to run a report (The expression is typed incorrectly, or is
too complicated to be evaluated......).

The query i based the report on runs fine. The report, Land Record report,
does not. The only fields that I could forsee having any issues are
numerical fields where I have subtotals and totals. The subtotals are
grouped by Segment (yes, such a field). This is an example of the language -
=Sum([State Amount]) Again, state amount is a field. I have the same
language for the totals, except that it is in the report footer grouped by
Grant Number.

Could there be an issue with using the same language, even though in
different parts of the report? I can't understand why this isn't working.

Linda

 

[Klatuu]

No, I did not miss the line where you said it is a field. I have to qualify,
because many posters use the word field when they mean control. Just wanted
to be sure were are talking the same thing. I did, however, miss the part
where you said what the message is.
If your query runs stand alone, that that should not be the problem. Do you
do any filtering in the report, for example, a Where argument in the
OpenReport method?
--
Dave Hargis, Microsoft Access MVP

You must have missed the line where I did say that State Amount is a field.
The message I am receiving doesn't have a number, just a statement, when I
attempt to run the report. FIrst the parameters appear, which I fill in,
then comes this lovely message: "This expression is typed incorrectly, or it
is too complex to be evaluated. For example, a numeric expression may
contain too many complicated elements.. Try simplifying the expression by
assigning parts of the expression to variables." I see that others have
received this message, but that there really isn't a simple resolution.


Linda

([State Amount]) must be a field in the report's record source. It cannot be
the name of a control on the report.

That being said, however, it is always best, when you are asking about an
error to include the error number and description, and point out the line of
code where the errror occurs, if it is in code.
--
Dave Hargis, Microsoft Access MVP

I've checked out the prior messages regarding the error message that appears
when attempting to run a report (The expression is typed incorrectly, or is
too complicated to be evaluated......).

The query i based the report on runs fine. The report, Land Record report,
does not. The only fields that I could forsee having any issues are
numerical fields where I have subtotals and totals. The subtotals are
grouped by Segment (yes, such a field). This is an example of the language -
=Sum([State Amount]) Again, state amount is a field. I have the same
language for the totals, except that it is in the report footer grouped by
Grant Number.

Could there be an issue with using the same language, even though in
different parts of the report? I can't understand why this isn't working.

Linda