查询问题 - 帮助！ [英] Query Problem - Help!

问题描述

我正在尝试创建的查询有轻微（但非常烦人）的问题。我会尽力解释我的工作情况吗？


我有3个表，一个是维护合同，一个是一般合同，另一个是供应商表。

两个合同表按供应商ID链接到供应商。供应商可以提供一般合同和维护合同。


我正在尝试按维护合同的数量，一般合同的数量，维护合同的总价值，一般总价值来生成一份报告来细分每个供应商合同，然后计算两者的总和（即合同总数和所有合同的总价值）


我使用以下代码来实现这个目标？

展开 | 选择 | Wrap | 行号

解决方案

您是否将supplierID = 0设置为Not Known？

您是否将supplierID = 0设置为Not Known？

是的。


谢谢

JD。

< blockquote>

是的。


谢谢

JD。

老实说，我看不出任何查询问题。大多数是与数据相关的其他事情。除非别人能发现某些东西。


抱歉。

Hi,

I am having a slight (but very annoying) problem with a query I am trying to create. I will try to explain what I am doing as best I can??

I have 3 tables, one is Maintenance contracts, one is for General Contracts and the other is a suppliers table.
The two contracts table link to supplier by Supplier ID. A supplier can supply both a general contract and a maintenance contract.

I am trying to produce a report that breaks down each supplier by the number of Maintenance contracts, the number of general contracts, the total value of the maintenance contracts, the total value of general contracts and then calculate a total for both (i.e. Total number of contracts and Total value of all contracts)

I am using the following code to achieve this??

Expand|Select|Wrap|Line Numbers

解决方案

Have you got a supplierID = 0 set to Not Known?

Have you got a supplierID = 0 set to Not Known?

Yep.

Thanks
JD.

Yep.

Thanks
JD.

I honestly can''t see any problem with the query. Most be something else going on with the data. Unless someone else can spot something.

Sorry.

这篇关于查询问题 - 帮助！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！