查询中的连接函数 - 与字符限制作斗争 [英] Concatenate function in a query - struggling with character limitation

问题描述

首先，我想对本论坛的所有用户表示感谢。即使没有注册用户，它在很长一段时间内也给了我很多帮助！


但现在我遇到了挑战，我试图通过以下方式解决这个问题看看几个类似的帖子，没有任何运气。


我使用了Allen Browne的conc函数。 http://allenbrowne.com/func-concat.html


我在名为Ingredients longitudinalwise的查询中使用该函数。将来自另一个查询的多行放在一起，称为向下成分。


我的挑战是串联给出的结果超过255个字符。我该怎么做才能确保结果不被截断？


调用函数的查询中的字段命名为成分列表。


我目前正在使用Access 2007.


非常感谢任何帮助。提前致谢！


Martin

Hi,

First of all I would like to express my gratitude to all users in this forum. It has really helped me a lot for a long time now, even without being a registered user!

But now I am stuck with a challenge, and I have tried to figure it out by having a look on several similar posts without any luck.

I have used Allen Browne''s conc function. http://allenbrowne.com/func-concat.html

I use the function in a query called "Ingredients lengthwise" that puts together multiple rows from another query called "ingredients downward".

My challenge is when the concatenation gives a result longer than 255 characters. What can I do to make sure that the result is not truncated?

The field in the query where the function is called, is named "ingredient list".

I am currently using Access 2007.

Any help is very much appreciated. Thanks in advance!

Martin

推荐答案

嗨Martin。欢迎来到 Bytes ！


我不确定这到底发生了什么。是否可以发布当前情况的详细信息，包括调用函数的SQL和函数本身的VBA。

Hi Martin. Welcome to Bytes!

I''m not sure exactly where this is occurring. Would it be possible to post the details of your current situation including the SQL where the function is called and the VBA of the function itself.

Hi NeoPa，


非常感谢你。


致函Allen Browne的功能：

Hi NeoPa,

Thank you very much.

Credits go to Allen Browne for the function:

展开 | 选择 | Wrap | 行号

Hi Martin ，


Access在查询中操作备忘录数据时有一个讨厌习惯，即使用255个字符的中间结果。

唯一的解决方案是存储结果在表格中并直接引用到那个备忘录结果字段。


Nic; o）

Hi Martin,

Access has a nasty habit of using a 255 character intermediate result when manipulating memo data in a query.
The only solution will be to store the result in the table and refer "directly" to that memo result field.

Nic;o)

这篇关于查询中的连接函数 - 与字符限制作斗争的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！