Query Expressions doesn't show up on Report

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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
 
-----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
Click to expand...
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?
 
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
Click to expand...
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?
 
Back
Top