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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

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
 

Forum statistics

Threads
1,141,918
Messages
5,709,339
Members
421,630
Latest member
MJ79

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top