输入参数值错误消息 [英] Enter Parameter Value Error Message
问题描述
你好,
我最近开始在我的信息系统管理课程中使用学校项目的访问权限。我是一名财务专业的学生,所以我不必深入了解这些内容,但我有一种奇怪的想法。我把我的表放在一起然后开始创建我的查询,它们都工作得很好但只有一个。我在论坛试图找出我的问题的解决方案之后阅读了论坛但没有运气我没有这个查询但是经过这么多阅读所有这些代码之后,我真的很好奇问题在哪里。
在有问题的查询中,我希望一个字段执行计算,将有问题的querry中的一列除以另一个querry中的数字,这恰好是一个数字查询。我按供应商ID对供应商进行了分组,并总结了我从每个供应商处获得的书籍数量,为每个供应商提供了一个UnitsInStock。我想将每个供应商的账面金额除以总数371,但这个数字是我的一个查询,库存总计的答案。因此,我使用表达式创建器创建了一个字段,该字段将每个供应商的SumOfUnitsInStock(有问题的查询中的字段)除以SumOfUnitsInStock中的一个字段,该字段在我的一个表中添加UnitsInStock字段。每次我运行它,它都会要求我输入库存总计的参数值!SumOfUnitsInStock。如果我输入371,这是相应的查询,它的工作原理。如何让它停止询问,以便它自己找到值。这是querry的SQL。我也使用了记录器,所以如果它有用,我会有一份副本。任何肝脏都会很好。
Hello,
I recently started working with access for a school project in my Information Systems Management class. I''m a Finance major so it''s not like I had to get this deep into this stuff, but I have a wondering mind. I put together my table and proceeded to creating my queries and they all work fine but one. I have read forum after forum trying to figure out the solution to my problem but no luck I could do without this query but after so much reading of all this code stuff I''m actually curious as to where the problem lies.
In the problematic query I want a field to perform a calculation that divides one of the columns in the problematic querry by a number in another querry, that just happens to be a one number query. I grouped my suppliers by supplierID and summed the amount of books I get from each giving me a UnitsInStock for each supplier. I would like to divide each supplier''s amount of book by the total which is 371 but this number is the answer to one of my queries, inventory book total. SO I used the expression maker to create a field that divides SumOfUnitsInStock of each supplier, a field in the problematic query, by SumOfUnitsInStock a field in a query that adds up the UnitsInStock field in one of my tables. Everytime I run it, it asks me to Enter Parameter Value for Inventory Book Total!SumOfUnitsInStock. If I enter the 371, which is the of the corresponding query it works. How do I get it to stop asking so it just finds the value on its own. This is the SQL of the querry. I also used the documenter so I have a copy of that if it helpful. Any hep would be nice.
推荐答案
您没有定义来源(在[FROM子句]作为[库存总计]。
SQL引擎将查看该表达式并将其视为可输入参数。基本上无法识别。
如果要包含来自单独查询的数据,则必须将其包含在FROM子句中(虽然不建议,但可以在这里使用DLookup() )。如果我理解正确,此查询始终返回单个结果。如果是这样,试试这个:
You have no source defined (in the FROM clause) as [Inventory Book Total].
The SQL engine will look at that expression and will treat it as an enterable parameter. Essentially unrecognised.
If you want to include the data from a separate query, you must include it in the FROM clause (It''s possible, though not advised, simply to use a DLookup() here). If I understand you correctly, this query always returns a single result. If so, try this :
你好,
我最近开始在我的信息系统管理课程中访问学校项目。我是一名财务专业的学生,所以我不必深入了解这些内容,但我有一种奇怪的想法。我把我的表放在一起然后开始创建我的查询,它们都工作得很好但只有一个。我在论坛试图找出我的问题的解决方案之后阅读了论坛但没有运气我没有这个查询但是经过这么多阅读所有这些代码之后,我真的很好奇问题在哪里。
在有问题的查询中,我希望一个字段执行计算,将有问题的querry中的一列除以另一个querry中的数字,这恰好是一个数字查询。我按供应商ID对供应商进行了分组,并总结了我从每个供应商处获得的书籍数量,为每个供应商提供了一个UnitsInStock。我想将每个供应商的账面金额除以总数371,但这个数字是我的一个查询,库存总计的答案。因此,我使用表达式创建器创建了一个字段,该字段将每个供应商的SumOfUnitsInStock(有问题的查询中的字段)除以SumOfUnitsInStock中的一个字段,该字段在我的一个表中添加UnitsInStock字段。每次我运行它,它都会要求我输入库存总计的参数值!SumOfUnitsInStock。如果我输入371,这是相应的查询,它的工作原理。如何让它停止询问,以便它自己找到值。这是querry的SQL。我也使用了记录器,所以如果它有用,我会有一份副本。任何肝脏都会很好。
Hello,
I recently started working with access for a school project in my Information Systems Management class. I''m a Finance major so it''s not like I had to get this deep into this stuff, but I have a wondering mind. I put together my table and proceeded to creating my queries and they all work fine but one. I have read forum after forum trying to figure out the solution to my problem but no luck I could do without this query but after so much reading of all this code stuff I''m actually curious as to where the problem lies.
In the problematic query I want a field to perform a calculation that divides one of the columns in the problematic querry by a number in another querry, that just happens to be a one number query. I grouped my suppliers by supplierID and summed the amount of books I get from each giving me a UnitsInStock for each supplier. I would like to divide each supplier''s amount of book by the total which is 371 but this number is the answer to one of my queries, inventory book total. SO I used the expression maker to create a field that divides SumOfUnitsInStock of each supplier, a field in the problematic query, by SumOfUnitsInStock a field in a query that adds up the UnitsInStock field in one of my tables. Everytime I run it, it asks me to Enter Parameter Value for Inventory Book Total!SumOfUnitsInStock. If I enter the 371, which is the of the corresponding query it works. How do I get it to stop asking so it just finds the value on its own. This is the SQL of the querry. I also used the documenter so I have a copy of that if it helpful. Any hep would be nice.
对不起阿德里安......不知道你在做这个一个....但至少我们都在思考相同的问题。
Sorry Adrian...did not know you were working on this one....but at least we were both thinking along the same lines.
这篇关于输入参数值错误消息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!