Crosstab queries average comes out different when analyzed in Exce

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

Guest

I have a crosstab queries with months and the month average in my columns. I
went to Tool -> Office Links -> Analyze with Excel because the people
reviewing it prefer to use Excel.

However, when you calculate the month average (from Jan-Sept) in Excel using
an Excel formula, the average is different from the Access average. It's not
by much, but it's not consistent. It may be a difference of .2% for one
person and .8% for another person.

Any ideas?
 
Thanks for responding. I did try and there aren't any null values. It's the
craziest thing.
 
Since we can't see your data and probably haven't experienced your issue,
there isn't much we can do to help. Again, "Did you try calc'n this
manually"?
 
To answer your question, when I said "I did try", I was saying that I tried
calculating manually. I guess my response wasn't clear. Thanks anyway.
 
We don't know how your manual calculation related to the crosstab or the
Excel values. We don't know your data. We can't see your SQL. We can't open
your Excel.
 
Back
Top