[AccessD] Any easy way to do this?

I very rarely getting written specifications of what the client wants.

That's what agile development methodologies are all about.

Frequently my clients don't know what they want, so I start with a simple prototype  and let 
the system evolve as the client realises what it is capable of providing.

-- 
Stuart

On 12 Apr 2010 at 16:02, Brad Marks wrote:

> "If you cannot tell me what you want how can I code it?"
> 
> 
> I love this quote... 
> 
> Printed it in a big font and framed it.
> 
> 
> 
> Brad
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Monday, April 12, 2010 3:49 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com