[AccessD] Any easy way to do this?

Naw, he just wants counts where MOB in (1,2) AND ...
(etc)

He uses these counts to decide which records to pull.

John W. Colby
www.ColbyConsulting.com


Charlotte Foust wrote:
> John,
> 
>> Is there a better way?
> 
> Shoot the client!!
> 
> I've done stuff somewhat similar to this before using classes ... I think!  I don't really understand what the client wants here.  Horizontal fields?  Vertical fields?  Huh??
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Monday, April 12, 2010 9:28 AM
> To: Access Developers discussion and problem solving; Sqlserver-Dba
> 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?
>