jwcolby
jwcolby at colbyconsulting.com
Mon Apr 12 11:28:29 CDT 2010
My client is constantly asking for "table counts" by which I mean filling in a table that looks kind of like a crosstab (but isn't) but for 4 or 5 vertical fields for 4 or 5 horizontal fields. FieldK FieldL FieldX FieldZ FieldA Cnt? Cnt? ? ? FieldB etc etc FieldC FieldD This isn't even a groupby since we are not talking values inside of FieldA, but rather a total count WHERE Field In ('X','Y','Z') and Field K is not null (or something similar). This is just killing me in terms of time to complete this as the only way I am thinking of is to create 16 count queries. Is there a better way? -- John W. Colby www.ColbyConsulting.com