Help with Access Page and displaying an average

[91PCL91]

This is my first post here so please bear with me.

I am creating an Access Page and on this page I have 4 dropdown boxes with
values from 1-5 in each. I am looking to see if there is a way to take the
values from those fields and then display the average of those in a seperate
textbox.

I was able to do this in an Access form but it required me using a Combo box
which creates two delimas for me...

1. The combo boxes create a difficult issue for reporting purposes since
each category in the combo box will require a seperate field in the table for
each rating rather then one field to highlight the user made selection.

2. The Form size is large and it does not load and function as efficiently
as an Access Page in HTM format would.

Any suggestions or assisatance would be greatly appreciated!

Thanks.

 

[amrtarek]

This is my first post here so please bear with me.

I am creating an Access Page and on this page I have 4 dropdown boxes with
values from 1-5 in each. I am looking to see if there is a way to take the
values from those fields and then display the average of those in a
seperate
textbox.

I was able to do this in an Access form but it required me using a Combo
box
which creates two delimas for me...

1. The combo boxes create a difficult issue for reporting purposes since
each category in the combo box will require a seperate field in the table
for
each rating rather then one field to highlight the user made selection.

2. The Form size is large and it does not load and function as efficiently
as an Access Page in HTM format would.

Any suggestions or assisatance would be greatly appreciated!

Thanks.