[AccessD] Crosstab question

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Tue May 6 10:57:41 CDT 2003


Hey guys, I am having trouble writing a crosstab query, what I have now, is

FILTER  Mo1  Mo2  Mo3  Mo4-6  Mo7-12 Yr2
aaa      1    2    2     22     11    2
bbb      1    4    4     33     33    3
ccc      1    1    1     11     11    1
ddd      2    2    2      2      2    2   etc.

I need it in this format --

DATE aaa bbb ccc
Mo1   1   1   1
Mo2   2   4   1
Mo3

I am using crosstab querry, in row heading I put FILTER, what do I put in
Column heading ?



-----------------------------------------
You are entitled to Get 100% FREE perfume (S&H is FREE)!
Click Here: http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail




More information about the AccessD mailing list