vipinkbhatt
New member
- Local time
- Today, 19:44
- Joined
- May 8, 2017
- Messages
- 2
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).
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).