|
|
Subject:
Microsoft Access Database Query - Bonus Tip for quick answer!
Category: Computers > Software Asked by: masterjdogg-ga List Price: $9.50 |
Posted:
06 Jan 2005 18:32 PST
Expires: 08 Jan 2005 09:20 PST Question ID: 453311 |
Please locate the attached database: http://www.angelfire.com/comics/tester02115/Tester.mdb I would like to take the ?Source? table and run a MS Access Query to actively create the query equivalent of the ?Result? table. I want to make sure that I can update the ?Source? table and actively create the Result. The desired query transposes the data from ?Source? and creates a unique entry for each ?Element? by Project ID. Upon transposition, the data is then grouped by catagory and scored using the legend table. Breakdown of the ?Result? table: "Catagory" is from the Legend table. Project ID is the Project ID from Source table. MaxScore is MaxScore by Element from the Legend Table. The Element value ?p? or ?f? make the Element score-able and therefore add the ?MaxScore? value to the ?PossibleScore? value for that Element. ?n? is ineligible ? not applicable to the ?PossibleScore.? Max score is taken from the ?Legend? table. ?p? is pass, means add the ?PossibleScore? value to the ?Score? value for that element. ?f? means fail or don?t add the ?PossibleScore? value to the Score value of that element. I think this is very straight forward and a simple task. If completed by 2 PM EST on Friday January 6th, I will include a 50% tip. Thank you. |
|
There is no answer at this time. |
|
There are no comments at this time. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |