William Hindman
wdhindman at dejpolsystems.com
Fri Nov 2 14:24:03 CDT 2007
...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