报告 [英] 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等内容）时，必须按所有未聚合的字段进行分组。您不能在同一个查询中同时执行月份和年份。


例如......

本月：

展开 | 选择 | Wrap | 行号

我有一个表格，其中包含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)

展开 | 选择 | Wrap | 行号

谢谢你的回复。


对不起我以前的帖子我忘记了提及其他字段即，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屋！