报告 [英] Reports
问题描述
我有一个包含Empid,Empname,Amount,Date_check_rcvd字段的表格。现在我的问题是我要生成一份报告,该报告按月收到的金额按年份和年份给出。我在编写查询时遇到问题,如果我说总和(金额)并执行查询,则会出现错误说您试图执行不包含指定表达式Empid作为聚合函数的一部分的查询。我在编写查询方面经验很少。我只是不知道出了什么问题?任何人都可以帮我解决????
Hi,
I have a table which contains the fields Empid, Empname, Amount, Date_check_rcvd. Now my question I want to generate a report which gives the sum of amount by month and by year thru the date of check recieved. I have a problem in writing the query where if I say sum(amount) and execute the query it gives an error saying " you tried to execute the query that does not include a specified expression Empid as part of aggregate function". I have very little experience in writing the queries. I just don''t know what is wrong??can anyone help me out????
推荐答案
我有一个包含Empid,Empname,Amount,Date_check_rcvd字段的表。现在我的问题是我要生成一份报告,该报告按月收到的金额按年份和年份给出。我在编写查询时遇到问题,如果我说总和(金额)并执行查询,则会出现错误说您试图执行不包含指定表达式Empid作为聚合函数的一部分的查询。我在编写查询方面经验很少。我只是不知道出了什么问题?任何人都可以帮助我吗????
Hi,
I have a table which contains the fields Empid, Empname, Amount, Date_check_rcvd. Now my question I want to generate a report which gives the sum of amount by month and by year thru the date of check recieved. I have a problem in writing the query where if I say sum(amount) and execute the query it gives an error saying " you tried to execute the query that does not include a specified expression Empid as part of aggregate function". I have very little experience in writing the queries. I just don''t know what is wrong??can anyone help me out????
使用聚合查询(查询Sum,Count,Avg等内容)时,必须按所有未聚合的字段进行分组。您不能在同一个查询中同时执行月份和年份。
例如......
本月:
我有一个表格,其中包含Empid,Empname,Amount,Date_check_rcvd字段。现在我的问题是我要生成一份报告,该报告按月收到的金额按年份和年份给出。我在编写查询时遇到问题,如果我说总和(金额)并执行查询,则会出现错误说您试图执行不包含指定表达式Empid作为聚合函数的一部分的查询。我在编写查询方面经验很少。我只是不知道出了什么问题?任何人都可以帮助我吗????
Hi,
I have a table which contains the fields Empid, Empname, Amount, Date_check_rcvd. Now my question I want to generate a report which gives the sum of amount by month and by year thru the date of check recieved. I have a problem in writing the query where if I say sum(amount) and execute the query it gives an error saying " you tried to execute the query that does not include a specified expression Empid as part of aggregate function". I have very little experience in writing the queries. I just don''t know what is wrong??can anyone help me out????
假设:
__1表名=表1
__2 [Empid]自动编号(主键)
__3 [Empname](TEXT 50)
__4 [金额](货币)
__5 [Date_check_rcvd](日期/时间)
Assumptions:
__1 Table Name = Table1
__2 [Empid] AutoNumber (Primary Key)
__3 [Empname] (TEXT 50)
__4 [Amount] (CURRENCY)
__5 [Date_check_rcvd] (DATE/TIME)
谢谢你的回复。
对不起我以前的帖子我忘记了提及其他字段即,Memosent数据类型日期/时间。现在当我运行你在帖子中给我的查询时,它会提示我输入参数值Memosent。当我在消息上单击确定时,报告将打开。
Thank you for the reply.
I am sorry in my previous post I forgot to mention other field i.e., Memosent which of data type date/time. Now when I run the query you have given me in the post it prompts me the message saying " enter the parameter value Memosent". When I click ok on the message then the report opens.
这篇关于报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!