>Hi everyone-
>
>I need to flip rows & columns, and some cases make new columns/fields depending on the data. For instance, in a table which has studentid,chargeamount,and chargetype, I need to set up a display in which each charge is listed on the left (1st col) and then chargeamounts for that chargetype are listed across under each student's id.
>
>I've been doing this by setting up different arrays, which requires quite a bit of coding & processing -- is there an easier way using SQL?
>Thanks-
>Carlie
Look at Cross-tab query, you may open file Vfpxtab.prg and read comments there.
Edward Pikman
Independent Consultant