Help..Summarization.. tnx guys!

brytboifreak

Hey guys i'm just new here and i have a problem..how will i'm going to summarize the records and transfer to another table(Table 2).for example i have my table (Table 1.) with the fields like Posting Date, Teller No and Transaction type.

Example

Table 1

Posting Date______Teller No______Transaction Type______Amount
11/15/07 _________Tel-01 _________ CD ____________100
11/15/07 _________Tel-01 _________ SD ____________ 50
11/15/07 _________Tel-02 _________ CD ____________200
11/15/07 _________Tel-01 _________ CD ____________150
11/15/07 _________Tel-02 _________ CD ____________200
11/16/07 _________Tel-01 _________ CD ____________100
11/16/07 _________Tel-01 _________ SD ____________100
11/16/07 _________Tel-01 _________ CD ____________100
11/16/07 _________Tel-02 _________ CD ____________100
11/16/07 _________Tel-01 _________ CD ____________100


Table 2- Summarized records from Table 1

Posting Date______Teller No______Transaction Type
11/15/07 _________Tel-01 _________ CD
11/15/07 _________Tel-01 _________ SD
11/15/07 _________Tel-02 _________ CD
11/16/07 _________Tel-01 _________ SD
11/16/07 _________Tel-01 _________ CD
11/16/07 _________Tel-02 _________ CD


How will I'm going to produce this summarized records? help experts..TIA


Woohhooh! i solved my own problem!
\:D/