Access 2000, Access level: beginner
Hello everybody,
I'm experiencing some difficulties adding values in a query. Here is a simplified description of my DB.
Table: Project
Fields: Proj_ID (Primary key), Proj_Name, Prio_desc, Comp_desc, VA_desc.
Table: Priority
Fields: Prio_desc (Primary key), Prio_Value
Table: Complexity
Fields: Comp_desc (Primary key), Comp_Value
Table: Value Added
Fields: VA_desc (Primary key), VA_Value
The fields With the same name are linked together
Essentially my user will enter a new project or modify the characteristics of an existing project.
I'm trying to make a query that will add the values and return a score that can be used to rank the order in which my projects need to be accomplished. Here is what I've done:
Query: Score
Fields: Proj_ID, Proj_Name, Expr1: [Score] [in criteria : ((Comp_Value + VA_Value) * Prio_Value)]
This does not work, I get a text box asking me to enter a parameter.
I welcome any and all advise.
Thank you in advance
Govyn