> > I have 3 tables of data as shown below. I want a summary of them as only three tables sum up the difference. ask experts for help. thank you very much!

>

>

> Put you sixty tables into one:

>

>

SELECT * FROM Cn1 INTO CURSOR Q1
> FOR i = 2 TO 60
> tablename='cn'+TRANSFORM(m.)
> INSERT INTO Q1 SELECT * FROM (m.tablename)
> NEXT
>

> Suppose this is your data in Q1

> Code Value

> 1 A

> 1 B

> 1 X

> 1 A

> 1 C

> 2 A

> 2 B

> 2 C

> 2 A

> 2 D

>

>

SELECT code, value, value FROM Q1 GROUP BY 1,2,3 ORDER BY 1,2 INTO CURSOR Q2
> DO (_genxtab) WITH 'xtab'
> BROWSE LAST NOWAIT
>

The result of the cosstabulation is:

>

> **Code A B C D X **

> 1 A B C X

> 2 A B C D

>

>

> If the looks you fancy matter:

> COPY TO xx.txt DELIMITED WITH "" WITH CHARACTER '/'

> MODIFY FILE xx.txt

>

> Result :

> 1/A/B/C/ /X

> 2/A/B/C/D/

>

> and that in turn can be futher prettyfied and imported into a table with two columns.

> -Anders

Anders, thank you very much. with his solution, my problem was resolved