两个表之间没有关系的查询 [英] Query between two tables with no relationship

问题描述

附加到这个问题的是一个MS-Access 2003文件，其中包含订单和生产数据库的设计。

数据库包含查询命名的订单后续


我想从订购数量中扣除产生的数量，并根据每个订购产品所需的日期获得剩余数量。


现在是3周寻找任何解决方案和没有

Attached to this question is a MS-Access 2003 file that contains the design of the orders and production database.
The database contains query named orders follow-up

I want deduct the quantity produced from the quantity ordered and get the remainder depending on the date required for each ordered product.

It is now 3 weeks looking for any solution and nothing

推荐答案

我不知道在查询中有什么方法可以做到这一切，但我对你的查询做了一些修改以收集总和生成的每个产品，然后构建一个报告，使用运行总和字段从生成的数量中减去订购数量，在订单完成后为您提供现金数量。我会留给您了解如何过滤旧订单的订单完成日期和关注的生产数量问题，但这应该让您开始。

I don''t know of any way to do all of this in a query, but I made a change to your query to collect the sum total of each product produced, then built a report that uses a running sum field to subtract the quantities ordered from what was produced, giving you an amount on-hand after the order is fulfilled. I''ll leave it to you to figure out how to filter order completion dates for old orders and the attendent production quantity issues, but this should get you started.

附加文件

Order And Production.zip （63.3 KB，86 views）

Attached Files

Order And Production.zip (63.3 KB, 86 views)

非常感谢Topher23为您提供快速和直接的回复

我将尝试考虑过滤订单完成日期，但我可能需要您的建议

非常感谢

Thank you very much Topher23 for you quick and straighforword reply
I will try to think about the filtering of the order completion dates but I may need your advice
thank you very very much

我在报告中做了一些改动，以获得剩余部分，而不是获得现有的实现，我想要产品的第3行牛奶是300而不是446因为它会复制上述数量的值并过滤报告以包含剩余部分我只是试图过滤报告但订单数量的运行总和将根据查询标准从第一条记录开始

，谢谢你提供给我的任何解决方案

I did a little change in the report to get the remainder in stead of getting the on-hand After Fulfillment and i want to make the line number 3 of the product milk to be 300 rather than 446 because it would duplicate the values of the above quantities and filter the report to contain the remainder only I tried to filter the report but the running sum of order quantities will start from the first record according to the query criteria
thank you for any solution you provide me

这篇关于两个表之间没有关系的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！