将一个场的多行组合成一个结果 [英] Combining Multiple Rows of one Field into One Result

问题描述

我有一个多关系数据库，我正在提取公司的联系信息，询问他们是否是种植者，以及通过catgeory产生的产品列表。我需要将产品列在一个字段中。


示例：

展开 | 选择 | Wrap | 行号

解决方案

您可以尝试使用adodb记录集并循环播放，为每个种植者连接产品


这是用于显示目的/导出到Excel吗？


HTH


Steve

您可以尝试使用adodb记录并且循环通过，为每个种植者连接产品


这是用于显示目的/导出到Excel吗？


HTH


Steve

是的，这是出于显示目的/导出到Excel。我不得不为另一个功能生成这个功能。我的另一个选择是用Excel将它们与Excel合并。


不幸的是，我的编码非常生疏，而且我在SQL或VBA方面不是很有经验。 （想要学习，但经理不会让我接受培训：|，他很好，但我们的IT员工不会批准。长篇故事。）

如果你有能力Excel，那将是最快的解决方案。


否则你有一个急剧的学习曲线，没有太多时间！


Steve

I have a multi relationship database and I''m pulling the company''s contact info, queryied if they are a grower, and a resulting list of their products by catgeory. I need to have the products listed all together in one field.

Example:

Expand|Select|Wrap|Line Numbers

解决方案

Hi,

You could try using an adodb recordset and looping thru, concatenating the products for each grower as you go

Is this for display purposes/export to Excel?

HTH

Steve

Hi,

You could try using an adodb recordset and looping thru, concatenating the products for each grower as you go

Is this for display purposes/export to Excel?

HTH

Steve

Yes, this is for display purposes/export to Excel. I''m having to generate this for another function to a contracter. My other option was to hand merge them in Excel with a macro.

Unforunately my coding is very rusty, and I''m not very experienced in SQL or VBA. (Want to learn but manager won''t send me to training :|, well he woudl but our IT staff won''t approve.long story.)

If you are competent in Excel, then that will be the quickest solution.

Otherwise you have a sharp learning-curve and not much time!

Steve

这篇关于将一个场的多行组合成一个结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！