查询和图表问题 [英] Query and Chart Questions

问题描述

我有一个列出供应商名称的查询。我还有一个供应商表，我只希望查询只提取该表中的供应商。我们被允许输入外部供应商，但列表只是向下一个部门提供有缺陷材料的内部部门。


此外，我在此查询中有参数，即Startdate和Enddate以及我希望这些在基于此查询的图表上列出。我该怎么做呢？可以吗？基本上我想要在报告上调用报告的日期范围。

I have a query that lists a supplier name. I also have a table of suppliers and I only want the query to pull only the suppliers that are in that table. We are allowed to type in outside suppliers but the the list is only internal departments that supplied defective material to the next department.

Also I have parameters on this query that are Startdate and Enddate and i want these to be listed on the chart that is based on this query. How do I do this? Can it be done? Basically I want the date range the report is called for on the report.

推荐答案

加入查询，按供应商表的供应商名称列出供应商名称。这将进行选择。

下次使用：

选择[StartDate：]作为StartDate，[EndDate：]作为EndDate，....来自tblX在[StartDate：]和[EndDate：]之间的供应商日期

获得想法？


Nic; o）

JOIN the query that lists a supplier name by the supplier name to the table of suppliers. This will do the selection.
Next use:

select [StartDate: ] as StartDate, [EndDate: ] as EndDate, .... from tblX where supplierdate between [StartDate: ] and [EndDate: ]

Getting the idea ?

Nic;o)

虽然Nico提到将查询链接到表格，但我认为他可能已经在他的SQL中忘记了这一点。

另外，请记住我们没有所有信息所以你会有填补空白并更改我们不得不猜测的任何错误的字段名。

尝试：

While Nico mentioned linking the query to the table I think he may have forgotten this bit in his SQL.
Also, remember we don''t have all the information so you will have to fill in the gaps and change any wrong fieldnames that we had to guess.
Try :

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | 换行 | 行号

呵呵？什么是supplierdate？

huh? what is supplierdate?

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