[AccessD] ...gurus only

...ah me ...leave it to you to catch that one, no wonder I've been spinning 
in circles ...the fields are indeed long integers though I can convert them 
readily :)

William

----- Original Message ----- 
From: "Drew Wutka" <DWUTKA at marlow.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, November 02, 2007 3:31 PM
Subject: Re: [AccessD] ...gurus only


> Hang on William, got a solution for you...have it posted in a
> minute...one quick question, when you said the fields aren't null, but
> are "", are you saying that they are text fields?  Just curious, not
> sure if I need to force the data to be numeric... I'll have it posted in
> a minute.
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
> Hindman
> Sent: Friday, November 02, 2007 2:24 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] ...gurus only
>
> ...the table was built from a crosstab query ...why?
>
> William
>
> ----- Original Message ----- 
> From: "Susan Harkins" <ssharkins at gmail.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Friday, November 02, 2007 2:58 PM
> Subject: Re: [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
>> -- 
>> 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
> The information contained in this transmission is intended only for the 
> person or entity to which it is addressed and may contain II-VI 
> Proprietary and/or II-VI BusinessSensitve material. If you are not the 
> intended recipient, please contact the sender immediately and destroy the 
> material in its entirety, whether electronic or hard copy. You are 
> notified that any review, retransmission, copying, disclosure, 
> dissemination, or other use of, or taking of any action in reliance upon 
> this information by persons or entities other than the intended recipient 
> is prohibited.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com