Search results for query: *

Thanks for the responses guys. I will try these out. Thanks again.

Is it possible to calculate the average of values entered into a form and display the result on that form? I have a short form that asks for scores from 6 judges. I need to be able to take the average of the scores given, the number of judges can be from 2 to 6, and display it on the form. I...

Bob, Thanks for the help. It looks like it works, I noticed the majority of the headings from the xls have spaces, so I think that is causing most of the problem. But at least now I know it can be done. Thank you very much.

Ok I was able to get some much needd sleep and found where I am supposed to place the code, but I am getting a Compile Error, Method or data member not found. The .BackStyle is highlighted on the debug screen. I am sure that i am doing something incorrectly, my VBA knowledge is nearly nil...

Bob, Thanks for your reply. I tried to use the code you provided, but was unable to locate the "OnFormat Event Procedure" in the detail section. I tried the code in the OnOpen field of the report itself, but that ended up giving a compile error (247 if I remember correctly). I am...

Does anyone one know if its possible to shade text boxes on a report if they pull a null and or zero value from a query? Thanks in advance, I am pretty new to this; but am very eager to learn.