Access Report calculations?

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

Guest

In my Access Report, I have calculations of =Sum([DTS]) and =Avg([DTS]). The
sum comes back with a lower number than what I add up manually in my database
column, therefore making the average number also lower. I am using MS Office
Professional 2002.
 
I have never seen this happen in hundreds of reports. Try paste your values
from the datasheet view of your report's recordsource into Excel and sum the
values there.
 
I pasted them into my excel program and the totals came out different in both
of the stated problems that I had. I have check just about everything I
possibly can to see about correcting this to no avail.

Dave

Duane Hookom said:
I have never seen this happen in hundreds of reports. Try paste your values
from the datasheet view of your report's recordsource into Excel and sum the
values there.

--
Duane Hookom
MS Access MVP
--

"Dave with XP SP2 Update Problem"
In my Access Report, I have calculations of =Sum([DTS]) and =Avg([DTS]).
The
sum comes back with a lower number than what I add up manually in my
database
column, therefore making the average number also lower. I am using MS
Office
Professional 2002.
Click to expand...
Click to expand...
 
The only thing that I can suggest (other than reviewing your data which none
of us can see) is make sure the DTS field is not from the most detailed
level of records..

What happens if you limit your report's record source to few records? Try a
bunch of stuff and come back with a report of what you tried and what you
found.

--
Duane Hookom
MS Access MVP


"Dave with XP SP2 Update Problem"
I pasted them into my excel program and the totals came out different in
both
of the stated problems that I had. I have check just about everything I
possibly can to see about correcting this to no avail.

Dave

Duane Hookom said:
I have never seen this happen in hundreds of reports. Try paste your
values
from the datasheet view of your report's recordsource into Excel and sum
the
values there.

--
Duane Hookom
MS Access MVP
--

"Dave with XP SP2 Update Problem"
In my Access Report, I have calculations of =Sum([DTS]) and
=Avg([DTS]).
The
sum comes back with a lower number than what I add up manually in my
database
column, therefore making the average number also lower. I am using MS
Office
Professional 2002.
Click to expand...
Click to expand...
Click to expand...
 
I worked on it somemore before I got your last email. I found that because I
had a formula in the DTS that was checking the difference between the listing
date and the sale date which would give me a numerical figure of how long the
property was on the market, it was screwing things up. I removed that
formula and replaced it with a field and it is working fine.

I thank you for your time,

Dave

Duane Hookom said:
The only thing that I can suggest (other than reviewing your data which none
of us can see) is make sure the DTS field is not from the most detailed
level of records..

What happens if you limit your report's record source to few records? Try a
bunch of stuff and come back with a report of what you tried and what you
found.

--
Duane Hookom
MS Access MVP


"Dave with XP SP2 Update Problem"
I pasted them into my excel program and the totals came out different in
both
of the stated problems that I had. I have check just about everything I
possibly can to see about correcting this to no avail.

Dave

Duane Hookom said:
I have never seen this happen in hundreds of reports. Try paste your
values
from the datasheet view of your report's recordsource into Excel and sum
the
values there.

--
Duane Hookom
MS Access MVP
--

"Dave with XP SP2 Update Problem"
In my Access Report, I have calculations of =Sum([DTS]) and
=Avg([DTS]).
The
sum comes back with a lower number than what I add up manually in my
database
column, therefore making the average number also lower. I am using MS
Office
Professional 2002.
Click to expand...
Click to expand...
Click to expand...
 
Try =Sum(Nz([DTS],0)), etc.
You might have some group that has Null values (which you are somehow
suppressing from being shown?) that are forcing your GrandTotals to "start
over". It's a quick fix. If that is the problem, it would be better to
incorporate NZ into the query the report is based on.

--
George Nicholson

Remove 'Junk' from return address.


"Dave with XP SP2 Update Problem"
I pasted them into my excel program and the totals came out different in
both
of the stated problems that I had. I have check just about everything I
possibly can to see about correcting this to no avail.

Dave

Duane Hookom said:
I have never seen this happen in hundreds of reports. Try paste your
values
from the datasheet view of your report's recordsource into Excel and sum
the
values there.

--
Duane Hookom
MS Access MVP
--

"Dave with XP SP2 Update Problem"
In my Access Report, I have calculations of =Sum([DTS]) and
=Avg([DTS]).
The
sum comes back with a lower number than what I add up manually in my
database
column, therefore making the average number also lower. I am using MS
Office
Professional 2002.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top