Changing report data source

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
Back
Top