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?
 
Did you try calc'n this manually? Are there some null values?
 
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.
 
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

How to convert Null values to zero when create an average query 1
Multiple expressions (Sum, Count, Average) of same value in crosstab query 3
average last 3 months in query 11
Calculate interest amount based on average daily balance 1
Help on crosstab query 2
Rolling 3 Month Average 1
Average of Subtotals in Pivot Table 0
Select vs crosstab query - different result 1

Back
Top