a function in specific field

[Rasha]

how can i make a specific field to be a sum of many other Fields in design table with out using codes

[JoeM]

Calculations should be handled at the query level, not at table level. Tables should just store raw data, not calculations.

Access added the ability to store calculations at the table level with Access 2010 (see: http://office.microsoft.com/en-us/ac...101820564.aspx), but many serious programmers think this is a bad idea and don't use it. One reason is because all the other relational database programs (like SQL, mySQL, Oracle) don't allow this, so if you ever had to to convert your Access database to one of these, you would have problems. And it kind of goes against the concept of how relational databases are supposed to work.