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.

"91PCL91" <(E-Mail Removed)> wrote in message
news:7E74EC74-E135-4D72-A153-(E-Mail Removed)...
> 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.
>