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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum a field with null value 5
sum error 2
SynNeed to account for null values in subreports 2
Access MSACCESS - Sorting report based on field calculated in the report 0
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Sort a calculated field 15
calculations in report controls 4
Calculating page/report sums using calculated data from subquery 6

Back
Top