Hi,

I Have below table

I want all rows with all coloumn from below table where ActCode is 1162828 and sum of DocAmount for DocNo. i.e where the docNo is repeated i want only one row with sum of amount of all repeated rows.

**

"Select *, Sum (DocAmount)  from TblPurLedTranData  whre TblPurLedtranData.ActCode='" & 1162828 & "' Groupby DocNo "

**

PosDate     DocDate     DocNo         DocAmount     DueDate    Status       Period     DocType    FinYear       Chan          ActCode
10/10/2018  12/10/2018  369896       36980          11/11/2018  INV         5          PUST         2018        PUST        1243684   
10/10/2018  12/12/2018  665          36000          11/01/2019  INV         5           CR          2018       PUST       1162828   
10/10/2018  10/05/2018  3620         25000          09/06/2018  INV         5           INV         2018        PUST        1162828   
10/10/2018  10/05/2018  3620         25000          09/06/2018  INV         5           INV         2018        PUST        1162828   
10/10/2018  10/05/2018  3620         -69800         09/06/2018  INV         5           INV         2018        PUST        1162828   
10/10/2018  10/05/2018  6500         10200          09/06/2018  INV         5           INV         2018        PUST        1162828   
10/10/2018  10/05/2018  9988         35600          09/06/2018  INV         5           INV         2018        PUST        1162828   

Thanks