data discrepancy in Pivot Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Xia - 20 Oct 2005 22:21 GMT

I have two pivot tables feed off from the same Access query. One is in Excel
workbook, another is in data access page. There is some data discrepancy
exists between them. How come? I really run out of idea what could cause the
problem.
Can someone please help me here?

Thanks a lot in advance!

Reply to this Message

Duane Hookom - 20 Oct 2005 23:00 GMT

If they were my pivot tables, I would drill down to find where they are
showing discrepancies.

Signature

Duane Hookom
MS Access MVP
--

>I have two pivot tables feed off from the same Access query. One is in
>Excel
[quoted text clipped - 5 lines]
>
> Thanks a lot in advance!

Reply to this Message

Frank Xia - 21 Oct 2005 00:17 GMT

Thanks for your rapid reponse. THere is some more information about the
problem: I exported from data access page to excel and data matchs the pivot
table sits in the original Excel workbook. So why the information displayed
in data access page is different from Excel? I know what data is diffeent but
I don't know why it is different even I choose all same filters.

Thanks for your help!

> If they were my pivot tables, I would drill down to find where they are
> showing discrepancies.
[quoted text clipped - 8 lines]
> >
> > Thanks a lot in advance!

Reply to this Message

Duane Hookom - 21 Oct 2005 02:05 GMT

I don't know if any of us have experienced the same issue. Again, I would
suggest you drill down and look at the "raw" records to find any clues.

Signature

Duane Hookom
MS Access MVP

> Thanks for your rapid reponse. THere is some more information about the
> problem: I exported from data access page to excel and data matchs the
[quoted text clipped - 21 lines]
>> >
>> > Thanks a lot in advance!

Reply to this Message