can textbox with =AVG() be edited?

  • Thread starter Thread starter marco_pb via AccessMonster.com
  • Start date Start date
M

marco_pb via AccessMonster.com

help please..
if the text box with formula AVG() can be edited, could someone please tell
me how? ^^

thanks in advance..
I would like to know and to implement it in my database..
FYI I'm using access 97

thank you
 
Dear Marco:

I'm quite perplexed about what you would expect to happen if you edit the
average value on the form. At that point, it would no longer represent the
average that was calculated.

Are you expecting that all the values that contributed to this average would
then change, so that it is still the average? Is there some method by which
you expect this would be done?

Perhaps I have just not understood at all what you mean. Would you care to
try again?

Tom Ellison
 
Tom said:
Dear Marco:

I'm quite perplexed about what you would expect to happen if you edit the
average value on the form. At that point, it would no longer represent the
average that was calculated.

Are you expecting that all the values that contributed to this average would
then change, so that it is still the average? Is there some method by which
you expect this would be done?

Perhaps I have just not understood at all what you mean. Would you care to
try again?
Click to expand...

sorry I'm not explaining this before..
I do have for example test1, test2. the average is test
for some students, they have test 1 and test 2, but others only have 1 test,
so i want to put it in the test text box, in order not to be confused with
the students that take 1 of 2 tests..

thank you in advance
Tom Ellison
help please..
if the text box with formula AVG() can be edited, could someone please
Click to expand...
[quoted text clipped - 6 lines]
thank you
Click to expand...
Click to expand...
 
Dear Marco:

I'm sorry, but I do not understand you.

Tom Ellison


marco_pb via AccessMonster.com said:
Tom said:
Dear Marco:

I'm quite perplexed about what you would expect to happen if you edit the
average value on the form. At that point, it would no longer represent
the
average that was calculated.

Are you expecting that all the values that contributed to this average
would
then change, so that it is still the average? Is there some method by
which
you expect this would be done?

Perhaps I have just not understood at all what you mean. Would you care
to
try again?
Click to expand...

sorry I'm not explaining this before..
I do have for example test1, test2. the average is test
for some students, they have test 1 and test 2, but others only have 1
test,
so i want to put it in the test text box, in order not to be confused with
the students that take 1 of 2 tests..

thank you in advance
Tom Ellison
help please..
if the text box with formula AVG() can be edited, could someone please
Click to expand...
[quoted text clipped - 6 lines]
thank you
Click to expand...
Click to expand...
Click to expand...
 
i am really sorry to not explaning to you clear

the point is.. for some reason, I only need to fill in the test textbox
(which is an average value), without filling in the test1 and test2 value..

hope I make it right this time..

thank you for your passion.
 
marco_pb said:
i am really sorry to not explaning to you clear

the point is.. for some reason, I only need to fill in the test textbox
(which is an average value), without filling in the test1 and test2 value..

hope I make it right this time..

thank you for your passion.
Click to expand...

Or the question can be:
can i do these?

test1 test2 test(=avg (test1 + test2)) => is it correct?
0 2 2 => because the value start from 1 to 4
1 0 1 => same reason
- - x => - (no input, empty); x (i want
to make an input here)

thank you in advance
 
It looks like you should be using Excel. In Access, we would expect each
test score to be a new record in a table. Also, the average of 0 and 2 is 1,
not 2.
 
Dear Marco:

It appears perhaps you might want this:

Rnd((test1 + test2) / 2 + 0.5), 0)

Does this help?

It is still almost impossible for me to tell exactly what you want.

We can direct you to Access help in other languages if there is some other
language that would be more comfortable.

Tom Ellison
 
thanks to all..
the normal average will return 2 and 0 into 1..
but in my scoring system, the valid value is in range of 1 to 4..
so 0 means that teh person take only 1 test out of 2 (so that 1 of the test
score is 0)

Instead of that, It is simpler if I can make it:
only input in average column if i want to input 1 test score only.
but the problem is, in query i have make the formula: test: (test1+test2)/2
thus i can not change the value appeared in the test column.

thank you for your helps... I really appreaciate this..

thank you
 
I am not quite sure I understand. I think you mean that if Test1 is 3 and
Test2 is 0 then you want to ignore Test2. If the default value of [Test1[
and [Test2] is 0 (rather than null) you could use:

Average: IIf([Test1]>0 And [Test2]=0,[Test1],([Test1]+[Test2])/2)

If the default value of [Test1] and [Test2] is Null, you could use:

Average: IIf([Test1] Is Not Null And [Test2] Is
Null,[Test1],([Test1]+[Test2])/2)
 
thank you, BruceM

I´m trying it and I will post the result as soon as I have time.. I am sorry
because this project has to be finished in the middle of April, so I have to
do others important things..

I really thank yyu for the answers I got here...
Have a nice day you all ^^

thank you
 
Back
Top