Xtab compute value from second row heading

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a crosstab query that has 2 levels of row headings. First is an individual ID, second is a group code to which the individual belongs. My question is, can I compute values based on the row2 (group) and column intersection and retain the number of individual ID row headings equal to what I started with? In other words, all individual rows with the same group code will have the same computed value. It's only when a row with a new group (row heading2) is detected that a new value gets computed
thanks
 
Can you provide some sample records and desired output?

--
Duane Hookom
MS Access MVP


JH Higgins said:
I have a crosstab query that has 2 levels of row headings. First is an
Click to expand...
individual ID, second is a group code to which the individual belongs. My
question is, can I compute values based on the row2 (group) and column
intersection and retain the number of individual ID row headings equal to
what I started with? In other words, all individual rows with the same group
code will have the same computed value. It's only when a row with a new
group (row heading2) is detected that a new value gets computed.
 
I have no idea what your original data looks like. It would also help to see
the SQL of your existing crosstab.
 
Back
Top