Answer to Question #5824 in Databases | SQL | Oracle | MS Access for jaykant jha

Question

Sample
DT AMT VNO VTYPE MPT
08/04/2011 11256 K0002 P M
08/04/2011 2818.75 K0002 P P
08/04/2011 2893 K0002 P P
08/04/2011 3047 K0002 P P
08/04/2011 2845.56 K0002 P P
08/04/2011 0.31 K0002 P T
08/04/2011 348 K0002 P T

We want to show the above data as per below format:
Sample
DT VNO AMT TERM PAMT
08/04/2011 K0002 11256 348.31 11604.31