Access Report

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

Guest

does anyone know why a report's results would change if the data hasn't. I
am summing a column of data that is blank and it shows a sum (should be
zero). Now it doesn't (sum is zero) Unfortunately the report was submitted
with the sum incorrect. The report was ran. changes were made. then report
was run again. a few of the columns where the changes were made don't add up
properly.
 
Do you have the sorting and grouping correctly set in your report? How are
you "summing"?
 
=Sum([FieldName]); What I think happened and I am not sure and I want to be
at least 90% sure of this before I report to my superior. The data was
modified, the field values changed but the sum did not when she ran the
report. Everyplace where there is an error is where values were changed. Now
I don't know if the person that ran the report had it opened when she made
the changes or what. But it appears that the report did not perform the
summing that happens in the Footer. I hope this helps.
 
I have never seen a single report that didn't accurately sum numeric values
in a group or report header or footer when Sum(...) was used.

--
Duane Hookom
MS Access MVP
--

Mykas_Robi said:
=Sum([FieldName]); What I think happened and I am not sure and I want to
be
at least 90% sure of this before I report to my superior. The data was
modified, the field values changed but the sum did not when she ran the
report. Everyplace where there is an error is where values were changed.
Now
I don't know if the person that ran the report had it opened when she made
the changes or what. But it appears that the report did not perform the
summing that happens in the Footer. I hope this helps.

Duane Hookom said:
Do you have the sorting and grouping correctly set in your report? How
are
you "summing"?
Click to expand...
Click to expand...
 
Back
Top