MS Access sum values of one field in all records of one table

[logamuthu]

I am noobie to MS Access but well-versed in Foxpro 2.5a for DOS and wish to migrate from Foxpro 2.5a for DOS to MS Access - hence need help with some basic questions - how to do in MS Access whatever I used to do easily in command line of Foxpro 2.5a for DOS.



My first question - How to sum values of one field in all records of one table in MS Access - equal to "Sum Receipt to x"; "Sum Expense to y; "?x,y" in Foxpro 2.5a for DOS.

Thanx in advance!

[alansidman]

How to sum values of one field in all records of one table in MS Access

In a query you could create an aggregate query

http://www.techonthenet.com/access/f...umeric/sum.php

Alternatively you could do a Dsum in a form.

http://www.techonthenet.com/access/f...omain/dsum.php

Alan

[logamuthu]

Many Thanx Alan!

After I dive deeper into MS Access, I shall try your two suggestions and get back to you.