Query Expressions doesn't show up on Report

[Mike]

For some reason the expressions from my query only show up
on the report if they express constant values. That is
when the expression is written:

Expr1: [Dollar Value]
It returns the correct number. However, if i write it as
[Dollar Value]+1
then it returns a blank.

This particularly confuses me because when I run the query
it calculates everything perfectly.

Help.
Thanks.
Mike

 

[David Dowdell]

Try:
=[Dollar Value]+1


For some reason the expressions from my query only show up
on the report if they express constant values. That is
when the expression is written:

Expr1: [Dollar Value]
It returns the correct number. However, if i write it as
[Dollar Value]+1
then it returns a blank.

This particularly confuses me because when I run the query
it calculates everything perfectly.

Help.
Thanks.
Mike

 

[Mike]

-----Original Message-----
Try:
=[Dollar Value]+1


For some reason the expressions from my query only show up
on the report if they express constant values. That is
when the expression is written:

Expr1: [Dollar Value]
It returns the correct number. However, if i write it as
[Dollar Value]+1
then it returns a blank.

This particularly confuses me because when I run the query
it calculates everything perfectly.

Help.
Thanks.
Mike


.
Thanks for you suggestion, but the expression itself

works fine. That is, when I run the query it shows correct
values from what are mostly nested IIf statements. The
problem is that those results don't then show up on the
report. I've doublechecked to make sure the TextBox is set
to "Visible" in their properties. Any thoughts?

 

[David Dowdell]

This could be caused by a duplication in field names (ie: both the query and
the report have a field named [Dollar Value].

-----Original Message-----
Try:
=[Dollar Value]+1


For some reason the expressions from my query only show up
on the report if they express constant values. That is
when the expression is written:

Expr1: [Dollar Value]
It returns the correct number. However, if i write it as
[Dollar Value]+1
then it returns a blank.

This particularly confuses me because when I run the query
it calculates everything perfectly.

Help.
Thanks.
Mike


.
Thanks for you suggestion, but the expression itself

works fine. That is, when I run the query it shows correct
values from what are mostly nested IIf statements. The
problem is that those results don't then show up on the
report. I've doublechecked to make sure the TextBox is set
to "Visible" in their properties. Any thoughts?