报告查询/建议 - 服装尺寸和数量 [英] Reporting Query/Suggestion - Garment Size and Quantity
问题描述
我需要建议哪种方法是完成此任务的最有效方法。我需要使用服装尺寸和数量来构建发票报告。不同尺寸的单独记录及其在装运表中的相应数量。我必须在一行中的发票报告中显示此信息，其中包含大小标签（S，M，L，XL，XXL）下的数量。 Access不允许在多个字段上进行分组，因此我必须坚持编程。我在考虑以下两种方法
a。我想出了一个嵌套的SQL来完成这项工作。
b。在显示报告之前，我会浏览记录集并编辑记录集以获得一行中的所有大小和数量。
c。 WILDER方法!!我更改了下面发布的查询以免除大小和数量信息，因此只有服装，样式和颜色组合的记录，然后为每个尺寸及其相关数量的每个组合运行查询，然后将这些值放在记录集并显示已编辑的记录集或在报告上手动设置这些值。 TBH我还没有真正想过在我没有通过计算部分的时刻进行展示。
但是在我退出任何这些方法之前我想知道是否有可能以
为单位1.以某种方式将查询中的三个字段分组
2.在报告显示之前打开报告时触发哪个事件表单导航
或者如果有人对Access Reports有更多的经验，因为我没有任何东西，他们可以通知我一种方式，我没有必要通过这一切。
Hi,
I need a suggestion as to which method will be most efficient way of accomplishing this task. I need to build invoice report with Garment Sizes and Quantity. There are seperate records for different sizes with their corresponding quantity in the shipment table. I have to display this information in Invoice Report in a single row with quntities under size lables ( S, M, L, XL, XXL ). Access doesnt allow grouping on multiple fields so i have to stick to programming. I was thinking of the following two methods
a. I come up with a nested SQL which does the job.
b. Before the report is displayed i go through the record set and edit the recordset to get all the sizes and quantity in one row.
c. WILDER APPROACH!! I change the query which i have posted below to exempt size and quantity information so there will be only record for Garment, Style and Colour combination and then run query for each combination for every size and their relevant quantity and then either place those values in the record set and displaying the edited record set or manually setting those values on the report. TBH i havent really thought about displaying at the moments as i havent gone through the calculating part.
But before i go down any of these approaches i want to find out if it is possible to
1. Somehow group three fields in a query
2. Which event is triggered when the report is opened just before its displayed and on form navigation
Or if some one has more experience with Access Reports as i dont have any and they can inform me of a way that i dont have to go through all this.
推荐答案
我为在自己的问题中发帖而道歉，但我需要尽快提供帮助。有人可以给我任何想法吗？
I apologize for posting in my own question but I need help as soon as possible. Could someone give me any ideas?
我认为交叉表查询会对你有帮助。在交叉表查询中，将Garmet名称或ID设置为行标题，将选择大小设置为列标题，然后将数量作为值进行求和或计数。
结果是每个服装的单个记录显示每个尺寸的数量。这是你想要实现的目标吗？
I think a crosstab query will help you. in the crosstab query set the garmet name or ID to the Row heading and Select Size as the Column heading then sum or count the Quantity as the value.
the result is a single record for each garmet displaying the quantity of each size. is this what you are trying to acheive?
我认为交叉表查询会对你有所帮助。在交叉表查询中，将Garmet名称或ID设置为行标题，将选择大小设置为列标题，然后将数量作为值进行求和或计数。
结果是每个服装的单个记录显示每个尺寸的数量。这是你想要实现的目标吗？
I think a crosstab query will help you. in the crosstab query set the garmet name or ID to the Row heading and Select Size as the Column heading then sum or count the Quantity as the value.
the result is a single record for each garmet displaying the quantity of each size. is this what you are trying to acheive?
感谢您的回复。我不认为它会有所帮助，因为该行必须由GarmentNumber，StyleNumber和ColourCode的组合决定。然后有每个尺寸的列，但我不必计数或总和，数量来自发货。
我将尝试交叉布，因为我从未尝试过，但同时我正在尝试这个对于每种尺寸，它确实需要一些时间来加载。我确实认为在这个陈述中可能存在一些逻辑错误，如下所示：
Thanks for the reply. I dont think it will help as the row has to be decided by Combination of GarmentNumber, StyleNumber and ColourCode. Then there is columns for each size but i dont have to count or sum, the quantities come from shipment.
I will give crosstab a try as i never tried it before but in the meanwhile i was trying this for every size it did take some time to load. I do face that there might be some logical mistake in this statement which is as follows:
这篇关于报告查询/建议 - 服装尺寸和数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
