每个记录在7天内计算重新发生的项目。 [英] Counting re-occuring items within 7 days for each record.

问题描述

我正在尝试在Ms Access 03中创建代码和/或查询，以计算客户在7天内购买同一产品的次数。

I am trying to create code and or a query in Ms Access 03 to calculate the number of times a customer has purchased the same product within 7 days.

展开 | 选择 | Wrap | 行号

推荐答案

您从哪个数据开始，采用什么格式？

What data are you starting with and in what format?

感谢您的回复，数据是从Excel电子表格导入的，该电子表格来自另一个导出信息的程序。数据位于Access表中，未链接。


再次感谢您的帮助。

Thanks for replying, the data is imported from an Excel spreadsheet which was from another program that exported the information. The data is located in an Access table and not linked.

Thanks again for your help.

您似乎无法获得我在问什么我需要一些示例输入数据（我想如果你试图创建一个列，你给出的例子中显示，那么所显示的数据肯定不是你开始的那个）。


Table MetaData也不会受到伤害 - 你现在看到你的问题对我来说没什么意义。这个概念看起来很简单，但是你的数据并没有太好用（不是我能看到的）。


请发布元数据（关于表的布局/结构）与我在我的示例中使用的方式相同。单击回复按钮，您将可以访问我使用过的所有代码。 PK& FK代表Primary Key&外键分别。

You don''t seem to be getting what I''m asking. I need some sample input data (I figured if you were trying to create a column which is shown in the example you give, then the data shown is surely not what you are starting with).

Table MetaData wouldn''t hurt either - you see your question makes little sense to me at the moment. The concept seems simple enough, but your data doesn''t tie in with it too well (not that I can see anyway).

Please post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I''ve used. PK & FK stand for Primary Key & Foreign Key respectively.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

这篇关于每个记录在7天内计算重新发生的项目。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！