1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access: How to link form to subform that averages ratings on diff projects / person?

Discussion in 'Business Applications' started by myllennium, Aug 4, 2006.

Thread Status:
Not open for further replies.
  1. myllennium

    myllennium Thread Starter

    Aug 4, 2006
    OK, I am an advanced computer user, but just began using MS Access for management of my company's database, and it is bafflingly complex with all of its possible functions!! I know that what I need to do is NOT hard, but I just do not have the experience or resources to do this quickly... I need an experienced user's COMPLETE DIRECTIONS and all info/formulas that will be necessary.

    My co.'s director of Marketing NEEDS ME to implement the following ideas into our Access DB of 3000 people.

    What we already have working are a basic Form and Table that have a variety of standard client data: e.g., Names/Addresses/Phone #'s, etc, etc.

    We are a market research firm, and work with clients on different types of projects. We rate the person's level of quality interaction with us on a scale of 1-5. We have a field now on our Form and in our Table that is called "Projects."

    The problem is that the rating we have displayed is simply THE LAST RATING that we gave them on the single last project...

    What he needs me to do is link this Project field FOR EVERY PERSON of our 3000 person DB to Another form or table that can show a list of ALL projects we have done with them where we can rate their interaction on EACH project separately. Ultimately, he wants the Original Table to display a MEAN AVERAGE rating of ALL the projects that we have worked with them in the past.

    I believe this has to be done through relational DB design... One problem that I foresee is the fact that it has to be dynamic for each person... That is to say, one person we might only work with for 3 projects, and another we might use for 20 - and I don't know how it would work coding an average for each person: is Access smart enough to not include Null values/fields in creating an average of a column and divide the total only by the number of cells that DO have a number in them? This is what i NEED!

    I am thinking about listing the Project Names we work with them on in Column 1, and then the rating each person receives in Column 2 in an attached Subform...

    But this brings me to another problem I am worrying about: Will I have to create 3000 subforms for each person in the DB? How will i link each person to this Subform?? I don't have the time to input each person's name as different columns or rows, for instance... Also, I need this system to be dynamic - it must be able to automatically accomodate new Records in the Original Database which are tied to this Subform...

    PLEASE HELP!! I know that is a lot of words to explain my worries, but I know a fairly simple solution is right under my nose. My Internship will be saved by anyone who helps me through a SOLUTION!! ;)

    Thanks so much IT Specialists!!!

  2. OBP


    Mar 8, 2005
    JOsh, Access is smart enough and versatile enough to do all that you need. It just needs the correct table/relationship design.
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/489435

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice