[AccessD] Any easy way to do this?

JC,

    Could you please provide some sample data along with corresponding sample output that is being sought ?

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: jwcolby 
  To: Access Developers discussion and problem solving ; Sqlserver-Dba 
  Sent: Monday, April 12, 2010 21:58
  Subject: [AccessD] Any easy way to do this?


  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