Crosstab queries average comes out different when analyzed in Exce

T

Tina

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?
 
T

Tina

Thanks for responding. I did try and there aren't any null values. It's the
craziest thing.
 
D

Duane Hookom

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"?
 
T

Tina

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.
 
D

Duane Hookom

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.
 
Top