新手试图连接 [英] Newbie trying to Concatenate
问题描述
您好,
希望这是一个简单的问题,有人可以轻松帮助我。我有一个有两个字段的表。第一个字段包含subnet_org,第二个字段包含子网。第一列有许多重复,因为一些orgs有许多子网....它们都列在第二个字段的个人行中。
组织子网
罗杰斯10.10.1.0/81
罗杰斯10.10.1.0/82
Shaw 10.10.1.0/24
Shaw 10.10.1.0/25
Shaw 10.10.1.0/38
Telus 10.10.1.0/39
Telus 10.10.1.0/40
Telus 10.10.1.0/41
Telus 10.10.1.0/42
Telus 10.10.1.0/43
我需要运行一个查询,其输出连接每个组织的子网....所以输出看起来如此:
Telus 10.10.1.0/39,10.10.1.0/40,0.10.1.0/41....etc
每个组织一行。
提前感谢任何人提供的任何帮助。
干杯!
Hello,
Hopefully this is a simple problem that someone can help me with easily. I have one table with two fields. The first field contains a subnet_org and the second contains a subnet. The first column has many duplicates because some "orgs" have numerous subnets....which are all listed in the second field in inidividual rows.
Org Subnets
Rogers 10.10.1.0/81
Rogers 10.10.1.0/82
Shaw 10.10.1.0/24
Shaw 10.10.1.0/25
Shaw 10.10.1.0/38
Telus 10.10.1.0/39
Telus 10.10.1.0/40
Telus 10.10.1.0/41
Telus 10.10.1.0/42
Telus 10.10.1.0/43
I need to run a query whose output concatenates the subnet for each org....so the output looks thusly:
Telus 10.10.1.0/39, 10.10.1.0/40, 0.10.1.0/41....etc
with one row for each org.
Thanks in advance for any help anyone can offer.
Cheers!
推荐答案
您好,
希望这是一个简单的问题,有人可以轻松帮助我。我有一个有两个字段的表。第一个字段包含subnet_org,第二个字段包含子网。第一列有许多重复,因为一些orgs有许多子网....它们都列在第二个字段的个人行中。
组织子网
罗杰斯10.10.1.0/81
罗杰斯10.10.1.0/82
Shaw 10.10.1.0/24
Shaw 10.10.1.0/25
Shaw 10.10.1.0/38
Telus 10.10.1.0/39
Telus 10.10.1.0/40
Telus 10.10.1.0/41
Telus 10.10.1.0/42
Telus 10.10.1.0/43
我需要运行一个查询,其输出连接每个组织的子网....所以输出看起来如此:
Telus 10.10.1.0/39,10.10.1.0/40,0.10.1.0/41....etc
每个组织一行。
提前感谢任何人提供的任何帮助。
干杯!
Hello,
Hopefully this is a simple problem that someone can help me with easily. I have one table with two fields. The first field contains a subnet_org and the second contains a subnet. The first column has many duplicates because some "orgs" have numerous subnets....which are all listed in the second field in inidividual rows.
Org Subnets
Rogers 10.10.1.0/81
Rogers 10.10.1.0/82
Shaw 10.10.1.0/24
Shaw 10.10.1.0/25
Shaw 10.10.1.0/38
Telus 10.10.1.0/39
Telus 10.10.1.0/40
Telus 10.10.1.0/41
Telus 10.10.1.0/42
Telus 10.10.1.0/43
I need to run a query whose output concatenates the subnet for each org....so the output looks thusly:
Telus 10.10.1.0/39, 10.10.1.0/40, 0.10.1.0/41....etc
with one row for each org.
Thanks in advance for any help anyone can offer.
Cheers!
我很快会找到你的答案,在我去睡觉前最后一个。
I''ll have an answer for you shortly, last one before I go tp bed.
您好,
希望这是一个简单的问题,有人可以轻松帮助我。我有一个有两个字段的表。第一个字段包含subnet_org,第二个字段包含子网。第一列有许多重复,因为一些orgs有许多子网....它们都列在第二个字段的个人行中。
组织子网
罗杰斯10.10.1.0/81
罗杰斯10.10.1.0/82
Shaw 10.10.1.0/24
Shaw 10.10.1.0/25
Shaw 10.10.1.0/38
Telus 10.10.1.0/39
Telus 10.10.1.0/40
Telus 10.10.1.0/41
Telus 10.10.1.0/42
Telus 10.10.1.0/43
我需要运行一个查询,其输出连接每个组织的子网....所以输出看起来如此:
Telus 10.10.1.0/39,10.10.1.0/40,0.10.1.0/41....etc
每个组织一行。
提前感谢任何人提供的任何帮助。
干杯!
Hello,
Hopefully this is a simple problem that someone can help me with easily. I have one table with two fields. The first field contains a subnet_org and the second contains a subnet. The first column has many duplicates because some "orgs" have numerous subnets....which are all listed in the second field in inidividual rows.
Org Subnets
Rogers 10.10.1.0/81
Rogers 10.10.1.0/82
Shaw 10.10.1.0/24
Shaw 10.10.1.0/25
Shaw 10.10.1.0/38
Telus 10.10.1.0/39
Telus 10.10.1.0/40
Telus 10.10.1.0/41
Telus 10.10.1.0/42
Telus 10.10.1.0/43
I need to run a query whose output concatenates the subnet for each org....so the output looks thusly:
Telus 10.10.1.0/39, 10.10.1.0/40, 0.10.1.0/41....etc
with one row for each org.
Thanks in advance for any help anyone can offer.
Cheers!
好的,我回来了,但前三个简单的假设:
OK, I''m back, but first three simple Assumptions:
- 表名是tblTest
- 字段1名称是[组织]
- 字段2名称是[子网]
- 完成所有工作的功能。查询中的计算字段''All_Subnets''为每个唯一的[Org]调用它:
- Function that does all the work. It is called by the Calculated Field ''All_Subnets'' in the Query for each unique [Org]:
ADezii ,
非常感谢您的快速回复。我不仅是VBA的新手,也是Access的新手。一旦我弄清楚我正在使用Access的问题,我肯定你的代码会非常有用。
我一直得到函数未定义我尝试运行查询时的消息。我知道这是我正在做或不做的事情,因为我可以运行调用函数的示例查询....就像Northwind类型的东西........但即使我重新创建完全相同的表,函数然后查询为Northwind示例...我仍然得到此错误。但是当我在我自己的查询中调用Northwind函数对我自己的表....它工作正常....去图!
无论如何,再次感谢.....我会继续堵塞!!
ADezii,
Thank you so much for your quick response. I''m not only new to VBA but also Access. I''m sure your code will work marvelously once I figure out the issues I''m having with Access.
I keep getting a "function is undefined" message when I try and run the query. I know it''s something I''m doing, or not doing, because I can run sample queries that call functions....like Northwind type stuff........but even if I recreate the exact same table, function then query as the Northwind sample...I still get this error. But when I call the Northwind function in my own query against my own table....it works fine....go figure!
Anyway, thanks again.....I''ll keep plugging away!!
好的,我回来了,但前三个简单的假设:
OK, I''m back, but first three simple Assumptions:
- 表名为tblTest
- 字段1名称为[Org]
- 字段2名称为[子网]
- 完成所有工作的功能。查询中的计算字段''All_Subnets''为每个唯一的[Org]调用它:
- Function that does all the work. It is called by the Calculated Field ''All_Subnets'' in the Query for each unique [Org]:
这篇关于新手试图连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!