My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Setting a quality score based on data enetered
|
|
 Jul 21 2008, 05:43 AM
Post
#1
|
|
|
New Member Posts: 12  |
I am using 2007 but in 2003 compaitble mode
I am collecting data and storing it in several tables, the data is entered via a form. I want to hold a quality score for each project based on whether or not certain key data has been entered. The ten key items are spread across 3 tables and I want to be able to count how many are present and set the quality filed accordingly, ie if 7 out of 10 are present then the quality score is 70%. is this possible? |
 |
 
|
|
Jul 21 2008, 06:01 AM
Post
#2
|
|
|
UA Editor + Utterly Certified Posts: 22,726 From: Melton Mowbray,Leicestershire (U.K) |
Hi
It's possible(at query level).. but I wouldn't recommend you store the result.. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif) |
|
|
|
|
Jul 21 2008, 06:03 AM
Post
#3
|
|
|
New Member Posts: 12 |
why shouldnt the result be stored?
|
|
|
|
|
Jul 21 2008, 06:07 AM
Post
#4
|
|
|
UA Editor + Utterly Certified Posts: 22,726 From: Melton Mowbray,Leicestershire (U.K) |
Hi
If any of the components that used in the calculation are changed/edited then the save result is redundant and of no use.. Calculating it using a query(when needed).. will always give you a real time and accurate result.. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif) |
|
|
|
|
Jul 21 2008, 06:13 AM
Post
#5
|
|
|
New Member Posts: 12 |
fair enough, all i need to do now is work out how to do it at query level :-)
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 19th June 2013 - 07:07 PM |