[AccessD] ...gurus only

Drew Wutka DWUTKA at Marlow.com
Fri Nov 2 14:31:19 CDT 2007


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.





More information about the AccessD mailing list