Google Answers Logo
View Question
 
Q: Microsoft Access Database Query - Bonus Tip for quick answer! ( No Answer,   0 Comments )
Question  
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.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy