Changing report data source

[Guest]

I have changed the query my report uses as its data source and now the field
that contains a sum of other fields in the report is referencing the wrong
data. For example: my original report had a field named "2004 data", and
another field that included the field "2004 data" in a sum calculation. This
field still exists in my new data source, and the "2004 data" field reports
the correct info, but my sum field now picks us a field named "2005 data"
when calculating the sum. This only happens when the other fields referenced
in the sum calculation are wither zero of null. I have tried using "nz" in
the sum field but it doesn't fix the problem. I'm wondering if there is any
known issue with changing the data source of a report?

 

[Jeff Boyce]

Marion

What expression are you using in the "sum" control that's giving you "2005
data"?

What SQL statement are you using in your new query? in your old query?