##how to update average if was 49 or 48##

[ali hawler]

Hiii everybody
I wanna is creating a table like this (Students Degree)

ID	Name	Degree1	Degree2	Depart

Then I have to create a Form depend on this table and must be a (command button) to update the (average) if was 49 or 48 to 50

That is mean, I want to average data from the degree fields and then if the average was 49 or 48 should be 50 when I click on a button in a form .
Nothing about 40 , 45 or 47 ...
I already added a new field for average and calculated it , but when I want to update this field by using (update Query) access refuse that and tell me (nonupdatable field !!!!)
So what should I do ???
Please help me
Please help me
Very necessary

[June7]

You want to average data from the degree fields? What's so special about 49 and 48? What happens at 40, 45, 47? What would you be updating? I don't see a field for this result. Shouldn't save to table anyway, just calculate when needed.

[ali hawler]

You want to average data from the degree fields? What's so special about 49 and 48? What happens at 40, 45, 47? What would you be updating? I don't see a field for this result. Shouldn't save to table anyway, just calculate when needed.

Yes bro , I want to average data from the degree fields and then if the average was 49 or 48 should be 50 when I click on a button in a form . Nothing about 40 , 45 or 47 ...
I already added a new field for average and calculated it , but when I want to update this field by using (update Query) access refuse that and tell me (nonupdatable field !!!!)
so what should I do ???
please help me

[June7]

Calculated fields are not 'updatable' by query - they calculate themselves as source data changes.

As already stated, should not save this calculated value into table anyway.

If you want to provide db for analysis, follow instructions at bottom of my post.