Sum Up multiple fields' value in a form

[ZaheerAliBaig]

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

 

[Uncle Gizmo]

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

Add an extra field to your table to create a group, I added "TestGrp". Fill it with the same information, I used an integer "1". Then run the following query:-

SELECT tblTestNames.TestGrp, Sum(tblTestNames.[Amount]) AS Expr1
FROM tblTestNames
GROUP BY tblTestNames.TestGrp;

 

[Uncle Gizmo]

On a second look at your question what I thought was a table design is probably text boxes on a form? It that's the case, my solution won't work.

 

[MajP]

its not working by Sum expression.

It should. Can you show us what you are doing wrong. What is the formula and where is it located?