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