I am using access for a Sales lead management database which I have created using a template.
I have a Customer Table, employee table, and opportunity table.
In the Opp table i have a field call Probability. This is a percentage field that is used to guess the likelihood of the job converting.
At the moment this field is simply a data entry field where you enter the probability.
I want to put some logic behind this. To do this I have come up with 10 Yes/No questions.
If the answer is yes, the score for that question is 10, if No, then zero. (I also have a couple of questions with 3 values, but can modify to simply yes no to get this working).
The total of the 10 questions then gives the probability e.g. six yes answers, and 4 no's means the probability is 60%
Soooo....I know what I want to do...But I have no idea how to set this up in Access. That is calculate the score using the questions, and have the probability populated into the Opp table.
I have a programming background, but not in access.
Any tips would be gratefully accepted...