[AccessD] ...gurus only

...looks can be deceiving :)

William

----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, November 02, 2007 3:37 PM
Subject: Re: [AccessD] ...gurus only


> This looks like an easy job for a bit of code.  And a real tough job for
> queries.
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Friday, November 02, 2007 11:46 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] ...gurus only
>
> ...ok, you too, eh :)
>
> ...given:
>
> fields        w        x        y        z        max        series
> data1        1        1                            1             2
> data2        1                  5                  5             3
> data3        1        4                  3        3             4
> data4                  2        3                  3             2
> data5        1        1        1        1        1             4
> data6                  1                            1             1
>
> 1) where max is the largest number in w/x/y/z and
> 2) where series is the total fields between the first one containing a
> number and the last containing a number
> 3) where empty fields contain "" rather than nulls
>
> ...two days and I've yet to come up with an answer to fill the max and
> series fields from the data in w/x/y/z.
>
> ...help!
>
> William
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.503 / Virus Database: 269.15.18/1104 - Release Date: 
> 11/1/2007
> 6:47 PM
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com