A.D.TEJPAL
adtp at airtelbroadband.in
Mon Nov 5 22:38:23 CST 2007
William,
If the number of value columns in crosstab style source table is likely to vary, a generic solution could be suggested, envisaging programmatic creation of required queries.
On the other hand, if you are in a position to use the original data in normalized state, a single crosstab query could be suggested. It would fetch the desired results, including the two extra columns (one showing max of values across columns and the other showing total number of columns spanned by the two outermost columns carrying explicit values).
Best wishes,
A.D.Tejpal
------------
----- Original Message -----
From: William Hindman
To: Access Developers discussion and problem solving
Sent: Saturday, November 03, 2007 00:15
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