Search results

How would I not include 0 "zeros" in the calculation of average? Thanks.

Yep, missinglingq that is exactly what I need. I have an option group. I can make the NA to equal 0 "zero". But how do I not include the zeros on the avg in the report? Right now the control source for this avg in report is: =Avg([eval_score]) Thanks much.

I do need the field to be a number because I have a text box that is displaying Average of the score field in a report. I just want the NA option for one of the categories and not to have NA or Null included in the Avg. Thanks.

I have an option box items 1-10 and want to add an NA option. On the NA option value, I want to put NA, but it says "the value you entered isn't valid for this field". I know this is happening because it expects a number. I do not want a number, I want to Enter NA or leave it null. Is this...

boblarsen to the rescue again. Thanks, that's what I needed. Got it calculating nicely now. you still 'da man'. Good Day bud.

How do I go about adding an average field in report footer that will give me the average of all the scores. Thanks. jwood29

that was it guys. I set the data entry to yes and defaults to null. Now form opens blank. Thank you.

I'm not sure I can use that code. as I am using embedded macro built from the command button wizard (I chose Add New Record option). If I choose event procedure to put the code on click event, then it removes the macro to save. Any suggestions? thanks.

I have a form called evaluation: After I have entered employee, category score, and comments. I click Save. Then Exit button. But when I open the form up again.... as user would do the next time. The employee and category are pre-populated already. I do not want this. I would want the...

What would the code look like for Form Close event to clear all fields, except my prepopulated today's date field. Mainly I want my text box Evaluator: to not have persons name from before. And the Employee to be null or blank in the drop down list. Thanks in advance.

I have Category Combo Box with: "Professional Dev" "Quality" "Quantity" "Appearance" "Time Managment" I would like to have my category combo box move down to next one in list after clicking Save button. Can someone get me in right direction for code on this. Thanks in advance. jwood29

damn, Bob you nailed it again. That was it, it worked like a charm. Thanks so much again. Very cool. I used the scales to give you positive feedback for reputation. Good Day bud.

I still cannot get the "Superior" to disappear once Save button is clicked. I put the code: score_opt_AfterUpdate in the form On Current event. The score_opt do disappear, just not the text in score_txt. So I tried this code on current event and got debug error. score_txt_Afterupdate. Thanks.

I have an Admin form that I need help with getting sum and/or average from two different tables. How would I go about getting a text box to display Sum or average of users evalution scores. Table: User user_name Table: Evaluation eval_score Table: Admin Form: user_name combo...

Thanks for the help guys. I have one more quick question. Now how do I make that text "Superior" disappear once the Save button is clicked. I got it working to save the number 9 (which displays Superior) for the category Professional Development. But when I move down to next category, the...

I have a combo box that when highlighted I would like to have it display description from another table in a text box. What would the code look like for this on click or after update. Thanks all. Example: Combo Box highlights "Quality of Work" (pulled from cat_name) Text...

Awesome: Got it to work guys. Boblarson nailed it. Thanks both of you for helping me get this working... Good Day. Final working Code: Private Sub score_opt_AfterUpdate() Select Case score_opt Case 1, 2 Me.score_txt = "Needs Improvement" Case 3 To 5...

I did look at the select case help in vba help, but am a bit confused. here is the code I have so far and it does not display anything. Private Sub score_opt_AfterUpdate() Select Case Score Case 1, 2 'Needs Improvement' Case 3 To 5 'Satisfactory' Case 6 To 8 'Above Average' Case 9, 10...

thanks pbaldy. I did the above and got it to display "Needs Improvement". But this only works for when I click radio button 1 in the group. How would I also have it say "Satisfactory" when a 3, 4, or 5 is chosen. Thanks.

I am trying to use an option group that has radio buttons 1-10, that when clicked it will display free text into another text box that I have. 1 and 2 would say: Needs Improvement 3, 4, 5 would say: Satisfactory 6,7,8 would say: Above Average 9 and 10: Superior. What would the code for...