Totalling columnwise

[dina1808]

I had created table as below, would like to get total column-wise. Pls help


So. No. Name. Maths Eng. Sci. Total
1. A 10 20 30

I'm looking to total maths, sciand English in total field....

[Bob Fitz]

Use a calculated field in a query. Something like Tot:[Maths] + [Eng] + [Sci]

EDIT
"Name" is a reserverd word in access and should not be used to name an object

[dina1808]

Thanks Bob, if possible could you plz list the steps I have to perform... Thanks

[Bob Fitz]

Open a new query in design view
Add you table to the query
Add your fields to the grid
Copy and paste the calculated expression I posted earlier in to the the first line of a blank column in the grid

[dina1808]

Got it.. Thanks a lot!!!!

Just to know, is there any possible to do the same in table itself rather than query...

[Bob Fitz]

Quite honestly I don't know, but I wouldn't even if I could.

[dina1808]

NP.. You are great!!!