ZaheerAliBaig
New member
- Local time
- Yesterday, 20:32
- Joined
- Jan 19, 2020
- Messages
- 1
Hi...
i have created a form in access. as below
Test Names Amount
Test1 100
Test2 200
Test3 50
Test4 120
When i select the test name the amount field autopopulates (by fetching data from another table)
i want the total of All 4 tests in the same form
Like Below
Total Amount 470 i.e:100+200+50+120=470
Please tell me how can i get the total Amount. its not working by Sum expression.
Thanks
i have created a form in access. as below
Test Names Amount
Test1 100
Test2 200
Test3 50
Test4 120
When i select the test name the amount field autopopulates (by fetching data from another table)
i want the total of All 4 tests in the same form
Like Below
Total Amount 470 i.e:100+200+50+120=470
Please tell me how can i get the total Amount. its not working by Sum expression.
Thanks