Enter Parameter Value Message Pops Up

G

Guest

Hi,
I am trying to figure out why I keep receiving a "Enter Parameter Value"
message when I run a simple select query.
I am trying to divide 2 fields w/in this query (YTD Green Coffee Vol / YTD
Devan hrs).
The query runs and provides the correct result, however it prompts me twice
to enter a parameter value for "YTD Green Coffee Vol & YTD Devan hrs".
Any ideas? See my SQL below:
SELECT Sum(Kent.[Green Coffee Volumes]) AS [YTD Green Coffee Vol],
Sum(Kent.[Roasted Coffee Volumes]) AS [SumOfRoasted Coffee Volumes],
Sum(Kent.[Label Weight Coffee Volumes]) AS [SumOfLabel Weight Coffee
Volumes], Sum(Kent.[Devanning Labor Hours]) AS [YTD Devan hrs],
Sum(Kent.[Roasting Labor Hours]) AS [SumOfRoasting Labor Hours],
Sum(Kent.[Total Avaialble Roasting Machine Hours]) AS [SumOfTotal Avaialble
Roasting Machine Hours], Sum(Kent.[Packaging Labor Hours]) AS [SumOfPackaging
Labor Hours], Sum(Kent.[Total Available Packaging Machine Hours]) AS
[SumOfTotal Available Packaging Machine Hours], Sum(Kent.[Total FY06 Variable
Expenses]) AS [SumOfTotal FY06 Variable Expenses], Sum(Kent.[Total FY06 Fixed
Expenses]) AS [SumOfTotal FY06 Fixed Expenses], ([YTD Green Coffee Vol]/[YTD
Devan hrs]) AS [Devanning Metric]
FROM [tbl date list] INNER JOIN (Kent INNER JOIN [qry KRP baseline] ON
Kent.[Plant Code] = [qry KRP baseline].[Plant Code]) ON [tbl date list].[W/E]
= Kent.[W/E Date]
GROUP BY ([YTD Green Coffee Vol]/[YTD Devan hrs]);
 
G

Guest

hi,

You have...

GROUP BY ([YTD Green Coffee Vol]/[YTD
Devan hrs]),
but earlier in the query this has been renamed to AS [Devanning Metric].
So just change the GROUP BY to...
GROUP BY [Devanning Metric]

Hope this helps,
geebee
 
G

Guest

Hi,
I tried it, but now I am prompted to enter a parameter for "Devanning Metric".

geebee said:
hi,

You have...

GROUP BY ([YTD Green Coffee Vol]/[YTD
Devan hrs]),
but earlier in the query this has been renamed to AS [Devanning Metric].
So just change the GROUP BY to...
GROUP BY [Devanning Metric]

Hope this helps,
geebee



Rob said:
Hi,
I am trying to figure out why I keep receiving a "Enter Parameter Value"
message when I run a simple select query.
I am trying to divide 2 fields w/in this query (YTD Green Coffee Vol / YTD
Devan hrs).
The query runs and provides the correct result, however it prompts me twice
to enter a parameter value for "YTD Green Coffee Vol & YTD Devan hrs".
Any ideas? See my SQL below:
SELECT Sum(Kent.[Green Coffee Volumes]) AS [YTD Green Coffee Vol],
Sum(Kent.[Roasted Coffee Volumes]) AS [SumOfRoasted Coffee Volumes],
Sum(Kent.[Label Weight Coffee Volumes]) AS [SumOfLabel Weight Coffee
Volumes], Sum(Kent.[Devanning Labor Hours]) AS [YTD Devan hrs],
Sum(Kent.[Roasting Labor Hours]) AS [SumOfRoasting Labor Hours],
Sum(Kent.[Total Avaialble Roasting Machine Hours]) AS [SumOfTotal Avaialble
Roasting Machine Hours], Sum(Kent.[Packaging Labor Hours]) AS [SumOfPackaging
Labor Hours], Sum(Kent.[Total Available Packaging Machine Hours]) AS
[SumOfTotal Available Packaging Machine Hours], Sum(Kent.[Total FY06 Variable
Expenses]) AS [SumOfTotal FY06 Variable Expenses], Sum(Kent.[Total FY06 Fixed
Expenses]) AS [SumOfTotal FY06 Fixed Expenses], ([YTD Green Coffee Vol]/[YTD
Devan hrs]) AS [Devanning Metric]
FROM [tbl date list] INNER JOIN (Kent INNER JOIN [qry KRP baseline] ON
Kent.[Plant Code] = [qry KRP baseline].[Plant Code]) ON [tbl date list].[W/E]
= Kent.[W/E Date]
GROUP BY ([YTD Green Coffee Vol]/[YTD Devan hrs]);
Click to expand...
Click to expand...
 
G

Guest

Hi,
I tried it, but now I am being prompted to enter a parameter for "Devanning
Metric".

geebee said:
hi,

You have...

GROUP BY ([YTD Green Coffee Vol]/[YTD
Devan hrs]),
but earlier in the query this has been renamed to AS [Devanning Metric].
So just change the GROUP BY to...
GROUP BY [Devanning Metric]

Hope this helps,
geebee



Rob said:
Hi,
I am trying to figure out why I keep receiving a "Enter Parameter Value"
message when I run a simple select query.
I am trying to divide 2 fields w/in this query (YTD Green Coffee Vol / YTD
Devan hrs).
The query runs and provides the correct result, however it prompts me twice
to enter a parameter value for "YTD Green Coffee Vol & YTD Devan hrs".
Any ideas? See my SQL below:
SELECT Sum(Kent.[Green Coffee Volumes]) AS [YTD Green Coffee Vol],
Sum(Kent.[Roasted Coffee Volumes]) AS [SumOfRoasted Coffee Volumes],
Sum(Kent.[Label Weight Coffee Volumes]) AS [SumOfLabel Weight Coffee
Volumes], Sum(Kent.[Devanning Labor Hours]) AS [YTD Devan hrs],
Sum(Kent.[Roasting Labor Hours]) AS [SumOfRoasting Labor Hours],
Sum(Kent.[Total Avaialble Roasting Machine Hours]) AS [SumOfTotal Avaialble
Roasting Machine Hours], Sum(Kent.[Packaging Labor Hours]) AS [SumOfPackaging
Labor Hours], Sum(Kent.[Total Available Packaging Machine Hours]) AS
[SumOfTotal Available Packaging Machine Hours], Sum(Kent.[Total FY06 Variable
Expenses]) AS [SumOfTotal FY06 Variable Expenses], Sum(Kent.[Total FY06 Fixed
Expenses]) AS [SumOfTotal FY06 Fixed Expenses], ([YTD Green Coffee Vol]/[YTD
Devan hrs]) AS [Devanning Metric]
FROM [tbl date list] INNER JOIN (Kent INNER JOIN [qry KRP baseline] ON
Kent.[Plant Code] = [qry KRP baseline].[Plant Code]) ON [tbl date list].[W/E]
= Kent.[W/E Date]
GROUP BY ([YTD Green Coffee Vol]/[YTD Devan hrs]);
Click to expand...
Click to expand...
 
G

Guest

I figured it out. Thanks....

Rob said:
Hi,
I tried it, but now I am being prompted to enter a parameter for "Devanning
Metric".

geebee said:
hi,

You have...

GROUP BY ([YTD Green Coffee Vol]/[YTD
Devan hrs]),
but earlier in the query this has been renamed to AS [Devanning Metric].
So just change the GROUP BY to...
GROUP BY [Devanning Metric]

Hope this helps,
geebee



Rob said:
Hi,
I am trying to figure out why I keep receiving a "Enter Parameter Value"
message when I run a simple select query.
I am trying to divide 2 fields w/in this query (YTD Green Coffee Vol / YTD
Devan hrs).
The query runs and provides the correct result, however it prompts me twice
to enter a parameter value for "YTD Green Coffee Vol & YTD Devan hrs".
Any ideas? See my SQL below:
SELECT Sum(Kent.[Green Coffee Volumes]) AS [YTD Green Coffee Vol],
Sum(Kent.[Roasted Coffee Volumes]) AS [SumOfRoasted Coffee Volumes],
Sum(Kent.[Label Weight Coffee Volumes]) AS [SumOfLabel Weight Coffee
Volumes], Sum(Kent.[Devanning Labor Hours]) AS [YTD Devan hrs],
Sum(Kent.[Roasting Labor Hours]) AS [SumOfRoasting Labor Hours],
Sum(Kent.[Total Avaialble Roasting Machine Hours]) AS [SumOfTotal Avaialble
Roasting Machine Hours], Sum(Kent.[Packaging Labor Hours]) AS [SumOfPackaging
Labor Hours], Sum(Kent.[Total Available Packaging Machine Hours]) AS
[SumOfTotal Available Packaging Machine Hours], Sum(Kent.[Total FY06 Variable
Expenses]) AS [SumOfTotal FY06 Variable Expenses], Sum(Kent.[Total FY06 Fixed
Expenses]) AS [SumOfTotal FY06 Fixed Expenses], ([YTD Green Coffee Vol]/[YTD
Devan hrs]) AS [Devanning Metric]
FROM [tbl date list] INNER JOIN (Kent INNER JOIN [qry KRP baseline] ON
Kent.[Plant Code] = [qry KRP baseline].[Plant Code]) ON [tbl date list].[W/E]
= Kent.[W/E Date]
GROUP BY ([YTD Green Coffee Vol]/[YTD Devan hrs]);
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why am I asked to enter parameter value? 2
Why am I asked to enter parameter value? (Second try) 3

Top