如何从报表中单个单元格中显示的字段中获取值？ [英] How to get values from a field shown in a single cell on a report?

问题描述

大家好！


我实际上是访问/ vba等的初学者。


和你们很多人一样，我也有问题。那个？什么？被调用？如何从表中的字段或报表中单个单元格中显示的查询中获取值？ （它们应该用逗号分隔，并且仅限于报告中的单元格）？


如果有人知道答案或者知道有关它的文章，那么，请你好心回复答案或指导我学习一些教程等。



非常感谢提前。

Hi to everyone!

I''m actually a beginner in access/vba etc.

Like many of you, I also have a problem with something. That ?something? is called ?How to get values from a field in a table or a query shown in a single cell on a report? (They should be separated with commas and limited to a cell in a report)?.

If somebody knows the answer to this or knows the article about it, please , be so kind to reply an answer or direct me to some tutorial or etc.


Many thanks in advance.

推荐答案

您想要从表/查询或报表中的字段中获取值？

You want to et a value from a table/ query or from a field in a report?

报表不是交互式界面。点击它没有回应。你需要使用一个表格。

A report is not an interactive interface. It doesn''t respond to clicking on it. You need to use a form for this.

大家好！


我实际上是访问/ vba等的初学者。


和你们许多人一样，我也遇到了问题。那个？什么？被调用？如何从表中的字段或报表中单个单元格中显示的查询中获取值？ （它们应该用逗号分隔，并且仅限于报告中的单元格）？


如果有人知道答案或者知道有关它的文章，那么，请你好心回复答案或指导我学习一些教程等。



非常感谢提前。

Hi to everyone!

I''m actually a beginner in access/vba etc.

Like many of you, I also have a problem with something. That ?something? is called ?How to get values from a field in a table or a query shown in a single cell on a report? (They should be separated with commas and limited to a cell in a report)?.

If somebody knows the answer to this or knows the article about it, please , be so kind to reply an answer or direct me to some tutorial or etc.


Many thanks in advance.

报告不是交互式界面。点击它没有回应。你需要使用一个表格。

A report is not an interactive interface. It doesn''t respond to clicking on it. You need to use a form for this.

也许可以通过使用一个查询来实现所需的结束，该查询将多个字段组合成一个所需格式的单个输出字段，然后在报告中使用它。

否则，正如mmccarthy所说，你可能需要使用一个表格。

Perhaps the desired end could be achieved by using a query which mushes the multiple fields together into a single output field in the required format, then using this in the report.
Otherwise, as mmccarthy says, you probably need to use a form.

这篇关于如何从报表中单个单元格中显示的字段中获取值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！