HI!
I am going crazy. Never had something like this before with forms. So therefore this question to you;
I made simple pivot table form on simple query. The query shows a different total quantity then the total quantity in the pivot table view form (no filters are on). Which is strange. BUT even stranger when showing the same form in datasheet lay out it shows the correct number of records and quantity (exactly matching the query). It seems like pivot table view drops some records compared to the datasheet vie?! I know which records are dropped but there is no logic at all to which ones and why...
Anybody a clue of what is going on??
Thx a lot!
Lobhaan
I am going crazy. Never had something like this before with forms. So therefore this question to you;
I made simple pivot table form on simple query. The query shows a different total quantity then the total quantity in the pivot table view form (no filters are on). Which is strange. BUT even stranger when showing the same form in datasheet lay out it shows the correct number of records and quantity (exactly matching the query). It seems like pivot table view drops some records compared to the datasheet vie?! I know which records are dropped but there is no logic at all to which ones and why...
Anybody a clue of what is going on??
Thx a lot!
Lobhaan
