[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