Search results

So I figured out the issue..... On my form I have several categories that you can choose a number rating for. For example: (Record 1) Permanency Prospects 5, Safety 4, Stability 3 = 12 (Record 2) PP 6, Safety 5, Stability 4 = 15 How do i get totals of the category...

ok...so would I need to make a code for each indicator? I thought I would be able to take the code and have it apply under each indicator in the overall score box?? Thanks!!

Thanks....it still didn't work, I am not sure if I did anything wrong...I copied and put everything in exactly as you said.....would you mind if I mailed you the database, maybe I have something set up in my tables incorrectly or something?

Hi....yes the field now displays------ #Name? I put the code in as a control source???

let me ask another question....for the categories I listed....does it matter if the box is a drop down vs a standard one?

=([Physical Support of the Child_D]+[Emotional Support of the Child_D]+[Participation and Engagement_D]+[Progress to Safe Case Closure_D])/4 is exactly what I have in the control source....which gives me an average, yet because I'm saying divide by 4 when I attempt to get an avg it's...

Hi, Thanks...I still got an error message???

Hi, Im fairly new to access and need help with my form. =([Physical Support of the Child_D]+[Emotional Support of the Child_D]+[Participation and Engagement_D]+[Progress to Safe Case Closure_D]) These are the categories that have a numeric rating of 0-6. I would like to get the average of...