Access Tip: Project Scoring

News User Comments History Notify Me

9/2/2009 1:23:49 AM
Access Tip: Project Scoring
By Richard Rost

I received a question from Keith who asks:

I have a database tracking projects. I need to be able to calculate a score for each project based on a number of different criteria such as the location, size, and timeframe of the project. I need to be able to easily change the criteria for each category, and the points allocated to each. How do you recommend I do this?

Click here for the answer and a video tutorial explaining it.

Permanent Link
Keywords: access tips project scoring category criteria sql vba

Post Reply

Comment from osman @ 8/27/2010

Can you use 2 recordsets (tables) in the same event and update both? and How?

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 1+5:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard