[AccessD] ...gurus only

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


More information about the AccessD mailing list