I am attempting to create a in-house questionnaire for our sales team to allow them to better quote for certain projects. There are a number of questions with multiple choice responses. Based on these responses i would like to generate a number which would relate to a specific multiplier which we use to add to the base figure for the job (hope this is making sense?)
Any suggestions for the best approach to this? It's a bit like those online personality questionnaires which give you a figure at the end of the questions saying if you scored 1-50 you are "insert generic state of mind here". If you scored 51-100, etc, etc.
I'm looking at building this initially in MS Access with the hope of upgrading to a web based system at some point).