How to sum unique records value in Report page (1 Viewer)

[vipinkbhatt]

Hi All,

Need help from the all of you experts on a an issue I am facing with summing the amount in MS access report.

Scenario:
----------
Cust ID Certificate No. Value Transaction Date Transaction Amt
1 1001 200.00 01/Apr/2017 50.00
1 1001 200.00 01/Apr/2017 125.00
1 1001 200.00 01/Apr/2017 25.00
2 1002 500.00 03/Apr/2017 400.00
2 1002 500.00 03/Apr/2017 100.00
3 1003 150.00 05/Apr/2017 150.00

I need the total "value" of unique "certificate no.", which should be 850 basis above details.

I have a query, which is linked with report. In field of the query, I can add one or multiple Cust ID to generate report(s).

 

[June7]

Textbox in report header or footer with an expression: = Sum([Transaction Amt])

 

[vipinkbhatt]

Sorry, I quoted wrong example. Please advise if only below details are there:

Cust ID Certificate No. Value Transaction Date
1 1001 200.00 01/Apr/2017
1 1001 200.00 01/Apr/2017
1 1001 200.00 01/Apr/2017
2 1002 500.00 03/Apr/2017
2 1002 500.00 03/Apr/2017
3 1003 150.00 05/Apr/2017