[AccessD] ...gurus only

Is this a crosstab?

Susan H. 


> ...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