C
comcontrol
Baffled by this...I have an external data source (Access
DB) populating a pivot table via MSQuery with timestamps
formatted as 2004-08-30 13:00:22. I then apply grouping.
When I group by year, month, or even day everything works
fine and the pivot table updates automatically as
expected. When the hours level grouping is added, new
records in my query (which are confirmed to exist) are no
longer updated in the pivot table whether I click the
Refresh (!) button or not. Any insight is GREATLY
Appreciated. As a note, I have no blank timestamp
fields. Is this a column number formatting issue with
this timestamp?
..
DB) populating a pivot table via MSQuery with timestamps
formatted as 2004-08-30 13:00:22. I then apply grouping.
When I group by year, month, or even day everything works
fine and the pivot table updates automatically as
expected. When the hours level grouping is added, new
records in my query (which are confirmed to exist) are no
longer updated in the pivot table whether I click the
Refresh (!) button or not. Any insight is GREATLY
Appreciated. As a note, I have no blank timestamp
fields. Is this a column number formatting issue with
this timestamp?
..