组合查询时的字段记录DISAPPEARS [英] Field record DISAPPEARS when combining queries
问题描述
您好
我创建了两个不同的查询（对于属于FRONT和REAR的产品），这些查询使用产品信息来过滤所有查询的总数（所有属于同一类别的总和） FRONT产品属于各个类别。同样的事情适用于第二个查询，但仅适用于属于REAR的产品。
两个查询（RED，BLUE，BLACK）的类别类型相同，我只是更改了" CRITERIA"在SEATING领域（FRONT，REAR）。查询工作完美。
查询FRONT显示：
L1（这是一个计算字段）
RED $ 20
BLUE $ 15
BLACK $ 40
查询REAR显示
L1 （与上面相同的计算字段）
-------- ----< ---注意：没有属于RED的REAR产品
BLUE $ 30类别，非常好。
BLACK $ 12
我想在报告中显示两个查询但是当我将它们组合在一起时结果DOESNT显示类别RED。即使在该类别中存在一些FRONT产品（在运行JUST FRONT查询时确实显示了这些产品）。
我该如何解决这个问题????
我需要创建报告完全如下所示：
L1
FRONT REAR MIX
RED 20 20
蓝色15 30 45
黑色40 12 52
谢谢
20
BLUE
15
BLACK
40
查询REAR显示
L1（与上述计算字段相同）
-------- ----< ---注意：没有属于RED的REAR产品
BLUE
Hello
I have created TWO different queries (for products belonging to FRONT and REAR) which use product information to filter the total (sum all belonging to the same category) of all the FRONT products belonging to every category. Same thing applies to the second query but just with products belonging to the REAR.
The type of categories are the same for both queries (RED, BLUE, BLACK) and i just change the "CRITERIA" under the SEATING field (FRONT, REAR). Queries work perfectly.
Query for FRONT displays:
L1 (which is a calculated field)
RED $20
BLUE $15
BLACK $40
Query for REAR display
L1 (same calculated field as above)
-------- ---- <--- NOTE: there were NO REAR products belonging to RED
BLUE $30 category, which is perfectly fine.
BLACK $12
I want to display both queries in a report but when i COMBINE them the result DOESNT display category "RED" even though there ARE some FRONT products in that category (which are indeed displayed when running JUST the FRONT query).
How can i fix this????
I NEED to create a report DISPLAYING exactly as follows:
L1
FRONT REAR MIX
RED 20 20
BLUE 15 30 45
BLACK 40 12 52
thanks
20
BLUE
15
BLACK
40
Query for REAR display
L1 (same calculated field as above)
-------- ---- <--- NOTE: there were NO REAR products belonging to RED
BLUE
这篇关于组合查询时的字段记录DISAPPEARS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
