如何使用DMax功能并将其应用于单个客户ID？ [英] How can I use DMax function and apply it to a single customer ID?

问题描述

我有一个名为rptHOTSTICKS_EXPIRING的报告。基于名为HOSTICKS_SHIPPING_REPORT Query的查询。查询包含以下字段：

ORDER_NUM（文本）

CUST_NUM（文本）

姓名，地址，联系信息，我认为不重要这个帖子

DATE_SHIP（日期）

然后我有一个字段

I have a report named "rptHOTSTICKS_EXPIRING" based on a query named "HOSTICKS_SHIPPING_REPORT Query". The query contains these fields:
ORDER_NUM (text)
CUST_NUM (text)
Name, address, contact info, I think not important to this thread
DATE_SHIP (date)
Then I have a field

展开 | 选择 | 换行 | 行号

推荐答案

我只是不知道你的意思是2岁或以上即将出现的棍棒。这些条款似乎与你帖子中的任何内容都没有关系。

从你的例子来看，为什么你不做那些在过去两年内没有订购的顾客的选择？

I just can''t figure out what you mean by "sticks that are coming up that are 2 years old or more". Those terms don''t appear to relate to anything in your post.
From your example, why don''t you just do a select from customers who haven''t ordered within the last 2 years?

ChipR，感谢快速回复。我之所以不想只看2年以上的订单，是因为（试图长话短说）这些棒是安全装置，我们实际上必须在旧订单成为两年之前发出新订单。在收到新订单后，客户发回旧订单*。他们永远不会没有棍棒。


我认为我按照这种方式安排的真正原因是因为我们测试了它们返回的棒并将它们放回库存中。为了确保我们有足够的支持来填写所有即将到来的订单，我们可能希望看看*只是*下个月的订单，或者*只是*我们在那之后的月份，而不是两年前的所有订单。我希望这能回答你的问题，并阐明我的努力。


如果你仍然认为我正在以错误的方式这样做，我愿意倾听。我认为你说的是​​有价值的，通常我必须让这些东西在我完全得到它之前解决一段时间。谢谢！

ChipR, thanks for the fast reply. The reason why I don''t want to just look at orders over 2 years is because (trying to make long story short) these sticks are safety devices and we actually have to ship a new order before the old order becomes two years old. The customer ships back the old order *after* receiving the new order. They can never be without sticks.

I think the real reason I have this arranged the way I do is because we test the sticks they return and put them back into inventory. To ensure we have enough sticks to fill all upcoming orders, we may want to look at *just* next month''s orders, or *just* what we need the month after that, and not everything over two years old. I hope this answers your question and sheds light on my efforts.

If you still think I''m going about this the wrong way I''m willing to listen. I think what you are saying has merit and usually I have to let these things settle in for a little while before I totally get it. Thanks!!

您能否根据您提供的字段和信息准确定义您希望在报告中看到的内容？

Can you define exactly what you want to see in the report based on the fields and information you''ve given?

这篇关于如何使用DMax功能并将其应用于单个客户ID？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！