Enter Parameter Value

[monrial]

Here is my query and I am getting the popup box of 'Enter Paramenter Value'
can someone help me, I am new to this and I was given this query and that person is not willing to help me.


UPDATE MonthTranslation, UsageCodeTranslation AS UsageCodeTranslation_1 SET oct.[Usage Definition] = UsageCodeTranslation.[Usage Definition], oct.MonthName = MonthTranslation.[Month Name], oct.[Usage Code] = UsageCodeTranslation.Usage_Code, oct.[Month] = MonthTranslation.Month;

[KLMCats]

Usually that happens when it does not recognise a variable name. Example if it is prompting for value of [Usage Code] that is where the problem is. Check all your spellings.

[rjhodges]

I agree with KLMCats. And I suspect that [Usage Code] might be the suspect. You have it spelled three different ways in your query: [Usage Code], [UsageCode], and [Usage_Code]. Might one of them be incorrect?