Calculated Field in Access Table

[ootkhopdi]

Hi

i have a table having fields...
S.No. Name Max Marks Marks Obtains %Marks
1 A 100 50 50%
2 B 100 65 65%

i want to set field Value of %marks as %age of Marks obtains in row..

how can do it..in same table..

please give me solution.

Thanks

 

[stumac]

Set the field type to calculated

In the field properties at the bottom of the table design view the expression would be: [Marks Obtains]/[Max Marks] and the format would be percentage.

Your field names must be correct in the expression.

 

[ootkhopdi]

Thanks Stumac...