Help! Grouping in Pivot Table

J

JoHickey

I have a pivot table that shows the aging of files. I run a report every
week to get new figures. I have a count of all the records and a field
showing the age of the file. As time goes by, records move from one aging
period to the next (eg. 0 - 15 days, 16 - 30 days). I manually grouped them
the first time to fit in categories 0 - 15, 16 - 30, 31 - 45, etc. Now I'm
in week two, and when the new information came into my pivot table, not only
are they in the wrong place, but somehow the figures got doubled. I
understand why they went to the wrong group, but have no idea why the count
would be doubled. Your help would be much appreciated!
 
V

Vincent Johns

It might help if you post the SQL of your actual Queries (maybe along
with sample data from your Table).

One way for counts to be erroneously doubled is to leave an unused
reference to an extra Table (or Query) containing 2 records somewhere in
your design. Each of those 2 records would be linked with all of the
records that you're really interested in. But it's not at all clear if
that's what's happening in your case.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Top