[AccessD] Any easy way to do this?

Good idea.

Or, ask the client to write down in plain english what he wants.  When he
finds he cannot express what he wants then you say, if you cannot tell me
what you want how can I code it.

If he can express it in plain english then it is easy to code.  I am not
saying effective but possible.  If you come across "doubts" refer it back to
him to re-express what he wants.

Amazing how many people cannot even write down what they want but they
"expect" the analyist/coder to "read my mind".

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, April 12, 2010 9:39 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Any easy way to do this?

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?

--
John W. Colby
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com