'Enter Parameter Value'

[SteveF]

As usual, it's probably me mising the point. But I am running a query that throws up 'Enter Parameter Value' and I can't understand what it's asking me for.

The odd thing is that if I just click ok then the query runs and gives me the answer I expect. I've read the help articles on the Microsoft site and searched the forum to no avail.

I'm fairly convinced it's to do with running a query on a field that is itself the result of another query. There's nothing missing or deleted, and the fields are named uniquely so I'm all out of ideas.

So, when a query asks for a 'Parameter Value', what is it looking for?

Any help appreciated.

 

[ajetrumpet]

that's a response due to the SQL statement not being written correctly. Either that, or you have referenced a control in the statement. Usually if you bypass a control criteria that pops up, it treats the bypass as a NULL value.

 

[boblarson]

So to go along with what Adam said, if you provide the SQL statement and the wording of the "parameter request" we might be able to help you get it fixed, if you can't figure it out yourself (which you might be able to now).

 

[ajetrumpet]

nice avatar Bob.

 

[SteveF]

Thanks guys, it's late now so I will look at this tomorrow. Appreciate your input.

 

[SteveF]

SELECT DISTINCTROW qryProductsUsage.CategoryID, qryProductsUsage.Section, Sum(qryProductsUsage.Consumption) AS [Period Usage], Sum(qryProductsUsage.Closing) AS [Stock On Hand], qryJob.Days, [Period Usage]/[Days] AS [Day Stock Usage]
FROM qryProductsUsage, qryJob
GROUP BY qryProductsUsage.CategoryID, qryProductsUsage.Section, qryJob.Days, [Period Usage]/[Days];


This throws up 'Enter Parameter Value' Period Usage. If I click ok then the query runs and producs the correct answer.

Most things I have been able to puzzle out with a little help here and there, but this one has me beat just now; I've been fiddling around with it for days and days.

The [Period Usage]/[Days] should result in a straightforward number. Any ideas or did I post the wrong thing?

 

[jal]

SELECT DISTINCTROW qryProductsUsage.CategoryID, qryProductsUsage.Section, Sum(qryProductsUsage.Consumption) AS [Period Usage], Sum(qryProductsUsage.Closing) AS [Stock On Hand], qryJob.Days, [Period Usage]/[Days] AS [Day Stock Usage]
FROM qryProductsUsage, qryJob
GROUP BY qryProductsUsage.CategoryID, qryProductsUsage.Section, qryJob.Days, [Period Usage]/[Days];


This throws up 'Enter Parameter Value' Period Usage. If I click ok then the query runs and producs the correct answer.

Most things I have been able to puzzle out with a little help here and there, but this one has me beat just now; I've been fiddling around with it for days and days.

The [Period Usage]/[Days] should result in a straightforward number. Any ideas or did I post the wrong thing?

The name

[Period Usage]

is an alias created on the fly by your query. I doubt you are allowed to use such an alias in the GROUP BY clause. Instead, maybe try putting the actual formula for [Period Usage] in the GROUP BY clause, namely:

Sum(qryProductsUsage.Consumption)

 

[SteveF]

Problem solved, again, many thanks for input. I keep thinking that I'm finished if I can just solve the next problem, but there always seems to be one more problem.........