STILL bad. NOT normalized. (lol)

Coins should be in a child table of Students as follows (by the way, I like the StudName field...could i be a StudName?)

Students: StudentID,StudName
StCoins: StudentID,Coins,Qty

You would convert by scanning through the original table, create parent Students records and child StCoins record.

>One friend ask me how to convert the non-normalize dbf to standard!
>
>

>badtable:
>
>StudentID    StudName    Coins      Qty
>-----------------------------------------
>PJ00001      May         5_Dollar    10
>PJ00001      May         2_Dollar     4
>PJ00002      John        10_Dollar    6
>PJ00002      John        2_Dollar     5
>PJ00002      John        1_Dollar     3
>PJ00003      Peter       5_Dollar     7
>PJ00003      Peter       1_Dollar    15
>PJ00004      Susan       10_Dollar    2
>PJ00004      Susan       5_Dollar     1
>...
>
>
>GoodTable:
>
>StudentID    StudName    1_Dollar  2_Dollar  5_Dollar  10_Dollar
>-----------------------------------------------------------------
>PJ00001      May            0         4         10         0
>PJ00002      John           3         5          0         6
>PJ00003      Peter         15         0          7         0
>PJ00004      Susan          0         0          1         2
>........
>
>

>
>
>For Report, simply use group can do it, but how to change the table
>into this structure na!?
>
>Thanks!