Points allocation

ElBenno

Board Regular
Joined
Jun 3, 2005
Messages
97
I am wanting to use a database for recording data from file reviews that we conduct. The questions asked can have 3 answers Yes, No or Not Applicable. what i want to happen is for every No answer a certain point score is allocated to it (eg if question 2 is answered No then it is worth 5 points). can this be done and if so how??

Kindest Regards
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
Hi

Yes this can be done. You could either store the points values in the underlying tables as you go (this is not the preferred option, for data integrity reasons) or you can calculate the points for each review via a query as and when you need it.

Using a query should be the preferred option. Without knowing your table set-up it is difficult to advise exactly how you should do this but conceptually you want to count the 'No' results for each review and multiply that count by, in this case, 5.

If you need more help with designing a query, post a description of your table set-up and where you want to see these results.

HTH, Andrew
 

Watch MrExcel Video

Forum statistics

Threads
1,114,093
Messages
5,545,916
Members
410,711
Latest member
Josh324
Top