Re: Help! Grouping in Pivot Table
- From: Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 23 Nov 2005 04:18:15 GMT
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 <vjohns@xxxxxxxxxxxxxxxxxx> Please feel free to quote anything I say here.
JoHickey wrote:
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!
.
- Prev by Date: Re: Assigning Sequence Numbers
- Next by Date: Re: Query question outstanding balance
- Previous by thread: Re: Assigning Sequence Numbers
- Next by thread: Re: Query question outstanding balance
- Index(es):
Relevant Pages
|
