**SOLVED**Calculated field in query not showing up in report
**SOLVED**
I have a query which has 14 calculated fields. I've found that, at least by default and the ways I've tried so far, that the only calculated fields in that query which will display are the ones which are in the last of the 'equation chain'. What I mean by this is as follows:
CalculatedField#1: [Table.Field#1]-[Table.Field#2]
CalculatedField#2: [CalculatedField#1]-[Table.Field#3]
Okay, so since the query is now using [CalculatedField#1] as part of another calculated field's expression, then I cannot display the calculated results of CalculatedField#1 in the report--only by removing CalculatedField#2 can the calculated results of the first field be shown.
Any ideas to getting around this? Thanks in advance. (Office 2007)
SOLUTION:
"Try repeating the calculation in the second field, rather than referring to the first calculated field:
CalculatedField#2: ([Table.Field#1]-[Table.Field#2])-[Table.Field#3]
See if that makes a difference to your report."
**SOLVED**
I have a query which has 14 calculated fields. I've found that, at least by default and the ways I've tried so far, that the only calculated fields in that query which will display are the ones which are in the last of the 'equation chain'. What I mean by this is as follows:
CalculatedField#1: [Table.Field#1]-[Table.Field#2]
CalculatedField#2: [CalculatedField#1]-[Table.Field#3]
Okay, so since the query is now using [CalculatedField#1] as part of another calculated field's expression, then I cannot display the calculated results of CalculatedField#1 in the report--only by removing CalculatedField#2 can the calculated results of the first field be shown.
Any ideas to getting around this? Thanks in advance. (Office 2007)
SOLUTION:
"Try repeating the calculation in the second field, rather than referring to the first calculated field:
CalculatedField#2: ([Table.Field#1]-[Table.Field#2])-[Table.Field#3]
See if that makes a difference to your report."
Last edited: