Floating average (if possible)

[Tony Pitts]

Hello,

I have an access 2003 report with 10 text boxes and 10 corresponding labels
in the report header. The text boxes are averages of numeric fields. Is it
possible to create code that will arrange the labels and corresponding text
boxes in descending order?
Example:
Text1 4.23
Text2 1.98
Text3 2.35
Text4 4.98
etc.

Text4 4.98
Text1 4.23
Text3 2.35
Text2 1.98

I have tried to find anything on the subject in google, and do not know how
to word it to search the MS database. Any point in the right direction (if
it is possible at all would do for starters)would be appreciated. I have a
general knowledge of Excel, and could probably code it, maybe I could import
it to Excel? The access database is of my making, very simple.

 

[Yaz]

Have you tried to arrange the data in a query first?

 

[Tony Pitts]

My report is based on a query. Last night I exported to excel, and the data
manipulation was easier. The information can either be in access or excel.
I made the call to use access. I might need to rethink. Maybe I am
overcomplicating the situation. I can get the same results using custom
filters and cell averages. If it is possible in access, I would like to
know where to start if it not too much trouble. Thank you, Yaz