MS Access 2013 Crosstab Query Count function not Displaying results property:
Details
My Crosstab query has 38 Row Headers, a Column Heading that has only 2 output results and a Total. The Total row function is "Count"
The underlying query has product specification data ( the 38 Row Headers) and a Class Description - The column Row. The data in this row header is which plants can produce this product. There are only 2 plant entries
Raw data
Product id Row 2 - 38 Class Description
1234567 % Water , etc Plant1
1234567 % Water , etc Plant2
1234567 % dirt , etc Plant1
1234567 % dirt , etc Plant2
1234567 % plastic , etc Plant1
1234567 % plastic , etc Plant2
What my crosstab should show using Count
Product id Row 2 - 38 total plants Plant 1 Plant 2
1234567 % Water, etc 2 1 1
1234567 % dirt , etc 2 1 1
1234567 % plastic, etc 2 1 1
What my crosstab should does show using Count
id Row 2 - 38 total plants Plant 1 Plant 2
1234567 % Water, etc 2 1 1
1234567 % dirt , etc 2 0 1
1234567 % plastic, etc 2 0 1
If I remove about 6 of the row header that show necessary specification data - then the cross tab performs correctly. Since I do need all 38 header row, I am looking for alternatives for displaying this data.
Note - I always need the 38 header row data and I can have up to 50 plants. I only recently added 6 more column of spec data that correspond to the Crosstab Header rows - so this error in the counting did not present previously. The number of plants change according to Business grouping of specifications. I have a table of all of the specification data and I can create a cross tab of the plant that have 3 field of the spec data.
How would I dynamically merge specification table and add the results of this crosstab and the and counters? The counters are always right in the limited crosstab.
Many thanks in advance,
Atin
Details
My Crosstab query has 38 Row Headers, a Column Heading that has only 2 output results and a Total. The Total row function is "Count"
The underlying query has product specification data ( the 38 Row Headers) and a Class Description - The column Row. The data in this row header is which plants can produce this product. There are only 2 plant entries
Raw data
Product id Row 2 - 38 Class Description
1234567 % Water , etc Plant1
1234567 % Water , etc Plant2
1234567 % dirt , etc Plant1
1234567 % dirt , etc Plant2
1234567 % plastic , etc Plant1
1234567 % plastic , etc Plant2
What my crosstab should show using Count
Product id Row 2 - 38 total plants Plant 1 Plant 2
1234567 % Water, etc 2 1 1
1234567 % dirt , etc 2 1 1
1234567 % plastic, etc 2 1 1
What my crosstab should does show using Count
id Row 2 - 38 total plants Plant 1 Plant 2
1234567 % Water, etc 2 1 1
1234567 % dirt , etc 2 0 1
1234567 % plastic, etc 2 0 1
If I remove about 6 of the row header that show necessary specification data - then the cross tab performs correctly. Since I do need all 38 header row, I am looking for alternatives for displaying this data.
Note - I always need the 38 header row data and I can have up to 50 plants. I only recently added 6 more column of spec data that correspond to the Crosstab Header rows - so this error in the counting did not present previously. The number of plants change according to Business grouping of specifications. I have a table of all of the specification data and I can create a cross tab of the plant that have 3 field of the spec data.
How would I dynamically merge specification table and add the results of this crosstab and the and counters? The counters are always right in the limited crosstab.
Many thanks in advance,
Atin
