how to find sum

[aneshskmr]

i need to find sum of three or more fieds in a table ...

[Bob Fitz]

I would suggest creating a query based on the table. Then create a calculated field with an expression, something like:
Total Absence:[Field1] + [Field2] + [Field3]
Replace Field1, 2 and 3 with the actual names of your fields.

[aneshskmr]

no use boss




i want knw abt how find sum of three field

I would suggest creating a query based on the table. Then create a calculated field with an expression, something like:
Total Absence:[Field1] + [Field2] + [Field3]
Replace Field1, 2 and 3 with the actual names of your fields.

[thebigthing313]

Bob Fitz's solution works, but he assumed that your fields were number fields. The results in the "Total" indicate that those fields are stored as Text Fields. You will either have to change the design of the table to make them number fields or you will have to replace the function with:

Total: Val([field1]) + Val([field2]) + ...

Quick suggestions, your field names may cause problems in the future as you work on this database. You may want do some research on naming conventions.

[aneshskmr]

thank u boss its working ,,,but if any field empty not get answr,,,, do u hav any solution 4 dis problem??

Bob Fitz's solution works, but he assumed that your fields were number fields. The results in the "Total" indicate that those fields are stored as Text Fields. You will either have to change the design of the table to make them number fields or you will have to replace the function with:

Total: Val([field1]) + Val([field2]) + ...

Quick suggestions, your field names may cause problems in the future as you work on this database. You may want do some research on naming conventions.

[thebigthing313]

Is there a reason you are not using number fields? This would all be much easier if you converted them.

Nonetheless, if you keep everything the same, then there's a slight complication since your fields can hold a NULL or a zero-length string. You can try:

Total: Val(Nz([Field1],0)) + Val(Nz([Field2],0)) + ...

[aneshskmr]

thank u very much boss...