M
Michel Peeters
I have a crosstabquery.
The 8 column headings are weeknr based on DateDif.
The value is the sum of Kg (double)
The rowheadings are fields from the customer table and ProductId.
The last columnheading shows TOTAL_Kg__8_WEEKS for the 8 weeks.
Problem: Altough the TOTAL_Kg__8_WEEKS is correct (= sum of the underlying
records), some of the 8 columns of the weeknr remain on SOME lines empty
(and they SHOULD not !!).
??
tks for helping
michel
The 8 column headings are weeknr based on DateDif.
The value is the sum of Kg (double)
The rowheadings are fields from the customer table and ProductId.
The last columnheading shows TOTAL_Kg__8_WEEKS for the 8 weeks.
Problem: Altough the TOTAL_Kg__8_WEEKS is correct (= sum of the underlying
records), some of the 8 columns of the weeknr remain on SOME lines empty
(and they SHOULD not !!).
??
tks for helping
michel