Update with Variable

[rtrinidad]

I'm working on a judging database. Judges enter scores in different 5 categories. These categories could be equal in weight (20% each) but I needed the option to alter the weight in each category.



This weight % changes based on who uses this database so I created a table with one record to hold the "weighted %" so it can be changed as required. I named the table PERCENTAGE with number fields for each category like TALENT, MEMORY, etc.

I created an Update Query where all the judges scores were added together and multiplied by a fixed weighted percentage.

(([judge1].[talentscore]+[judge2].[talentscore]+[judge3].[talentscore])*.22)

What I need is to replace the fixed .22 with the weight % in the PERCENTAGE database. I tried the following but it does not find the value in the PERCENTAGE table.

(([judge1].[talentscore]+[judge2].[talentscore]+[judge3].[talentscore])*[percentage].[talent])

How do I get the value of the TALENT field in the single record of the PERCENTAGE database?

Thanks

[rtrinidad]

OK, I just learned how to setup global variables in a module. Using the current code in my Update Query, how do I retrieve the value of the global variable?

Update To: (([judge1].[talentscore]+[judge2].[talentscore]+[judge3].[talentscore])*GLOBAL VARIABLE VALUE)

[pbaldy]

You can't directly. You have to create a function that returns the value of the variable, and use that:

(([judge1].[talentscore]+[judge2].[talentscore]+[judge3].[talentscore])*FunctionName())

[rtrinidad]

Got it! Thanks.

[pbaldy]

No problem.