c**t
发帖数: 2744 | 1 Table:
Cat Acct num
1 abc x
2 abc y
1 def z
2 deg x
I want to get recordset like:
Acct Cat1 Cat2 num
abc x y x+y
def z 0 z
deg 0 x x
Thx | b*e
发帖数: 3845 | 2 what if you have one more abc,
so the number of column will be uncertain.
【在 c**t 的大作中提到】
: Table:
: Cat Acct num
: 1 abc x
: 2 abc y
: 1 def z
: 2 deg x
:
: I want to get recordset like:
: Acct Cat1 Cat2 num
: abc x y x+y
| c**t
发帖数: 2744 | 3 The distinct cat is fixed.
If there has one more record " 1 abc x1",
to do this:
abc sum(x) sum(y) sum(x)+sum(y)
【在 b*e 的大作中提到】
: what if you have one more abc,
: so the number of column will be uncertain.
|
|
