日期范围的总和 [英] Sum of Date Range

问题描述

大家好 -


我希望能够按日期范围提取我的技术产品，一切都在实际生产数量之外。我将其设置为总和，并通过将日期范围分配给它将起作用的查询中的[日期]来假设。然而，无论我投入什么日期，它都需要完整的生产总和。我附上了查询和表格的图像。请指教。


谢谢，

Daniel

附加图像

（31.6 KB，736 views）

解决方案

请打开您的查询。

右键单击表格区域的空白区域

从弹出窗口中选择SQL视图

复制

点击帖子工具栏中的 [CODE /] 按钮

将SQL粘贴到代码标签之间。

我们来看看......


（访问也很好：>在发布（VBA或SQL）代码之前，它将为您提供一些关于如何格式化已发布的SQL以便更容易在线程中读取的好提示（^ _^））

展开 | 选择 | Wrap | 行号

乍一看，

字段名为[Date]

if可能将名称更改为日期以外的名称因为它是一个保留的令牌
访问2007保留字和符号
AllenBrowne-访问中的问题名称和保留字词


2）表格字段[日期]是实际日期/时间数据类型吗？

Gota短时间退出...... Neopa，Rabbit，Twinnyfo可能会出现并伸出援助之手。 （^ _ ^）

Hello all -

I would like to be able to pull my tech''s production by date range and everything is working aside from the actual production number. I set it as sum and assumed by assigning the date range to the [Date] in the query that it would work. However it is taking a complete sum of the production regardless of what dates i put in. I attached images of my query and table. Please advise.

Thanks,
Daniel

Attached Images

(31.6 KB, 736 views)

解决方案

Please open your query.
Right click in a blank area of the table section
Select SQL View from the popup
Copy
Click on the [CODE/] button in the post toolbar
Paste your SQL between the code tags.
We''ll take a look...

(also would be good to visit: > Before Posting (VBA or SQL) Code as it will give you some good tips on how to format your posted SQL for easier reading in the thread (^_^) )

Expand|Select|Wrap|Line Numbers

Just at first blush,
Field named [Date]
if possible change the name to something other than "Date" as it is a reserved token
Access 2007 reserved words and symbols
AllenBrowne- Problem names and reserved words in Access

2) Is the table field [date] an actual date/time datatype?

Gota step out for short time... Neopa, Rabbit, Twinnyfo might pop in and lend a hand too. (^_^)

这篇关于日期范围的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！