使用Microsoft图形在子窗体中显示 [英] Using Microsoft graphs to Display In Subform

问题描述

我正在使用Access 97来构建我的数据库。我希望在运行查询时，从查询结果中填充图表。目前我正在使用表单来填充查询，然后查询将结果记录显示在子表单的数据表视图中。这是我想在图表上显示的结果记录。我想在图表上的字段是Prod_Code和Claim_Date。谢谢你的帮助。

I am using Access 97 to build my Database. I would like when my query is run, to populate a graph from the results of the query. Currently I am using a form to populate the query, and the query is then displaying the resulting records into a datasheet view on a subform. It is the resulting records I would like displayed on the graph. The fields I want on the graph are Prod_Code and Claim_Date. Thanks for the help.

推荐答案

我甚至不确定Access是否有图形化（我可能在这里证明是错误的）。

Excel当然可以很好地处理它们。可能是一个可行的解决方案吗？

I''m not even sure Access does graphing (I''ll probably be proved wrong here).
Excel, of course, handles them very well. Might that be a viable solution?

您是否尝试在表单上插入Graph对象？

只需使用您的查询作为源。


Nic; o）

Did you try to insert a Graph object on a form ?
Just use your query as the source.

Nic;o)

是的，我正在使用插入图形函数，并引用我的查询。问题是当表单打开时，查询由图形运行并产生无用的数据。我需要它等到我从表单运行查询。

Yes, I am using the insert graph function, and referencing my query. The problem is that the when the form is opened, the query is run by the graph and produces useless data. I need it to wait until I run the query from the form.

这篇关于使用Microsoft图形在子窗体中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！