473,407 Members | 2,306 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

Please help: How to concatenate fields in querie??

Hi all,

I have a seemingly small problem

I have a query returning e.g.:

Field1 Field2
A 1
A 2
A 3
B 6
B 4
B 9
C 2
C 4
C 6

In a second query I want the query result to be:

Field1 Field2
A 1,2,3
B 6,4,9
C 2,4,6

I would appreciate it if anyone could inform me how to accomplish this. I
have read some previous postings on similar subjects, but many solutions
seem to be pretty complicated to me.

Is there a easy way?

Why is there not a standard function in Access that would do just this?

Thanks a lot in advance!!

Maarten
Nov 13 '05 #1
2 1953

Maarten van der Cammen wrote:
Hi all,

I have a seemingly small problem

I have a query returning e.g.:

Field1 Field2
A 1
A 2
A 3
B 6
B 4
B 9
C 2
C 4
C 6

In a second query I want the query result to be:

Field1 Field2
A 1,2,3
B 6,4,9
C 2,4,6

I would appreciate it if anyone could inform me how to accomplish this. I
have read some previous postings on similar subjects, but many solutions
seem to be pretty complicated to me.

Is there a easy way?

Why is there not a standard function in Access that would do just this?

Thanks a lot in advance!!

Maarten

Very very similar question...
If it doesn't make sense, say so, and we can help.

See my post here....

http://groups.google.ie/group/comp.d...390721c2dbdd0f

osmethod

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Gert v O | last post by:
I've posted the following question once: I have a column in a table The first 1, 2 or 3 alphabetic characters of gives the category of the example: ms123 --> category MS f-2345 -->...
9
by: hope | last post by:
Hi Access 97 I'm lost on this code please can you help ================================= Below is some simple code that will concatenate a single field's value from multiple records into a...
11
by: kimberly.shaffer | last post by:
I think I am so lost!! Please someone write out DCONCAT explanation. Is it DConcat("FieldYouWantToConcatenate","TableFieldIsLocatedIn","WHATIDGOESHERE", "@SignOrOtherDelimiter",...
2
by: Kevin | last post by:
Hello, How do I concatenate two fields in the same table... For example, I have two tables, first one is called familynametable that has a familyID and familyname field. This table is connected...
2
by: Rico | last post by:
Hello, I'm wondering if there is a way to concatenate two fields or a field and a string value in a single field in a view? Where in Access I might write; & " (m3)" as TotalVolume is...
2
by: exapplerep | last post by:
I've seen how to use VBA code to concatenate two fields into a third by using an expression in the "After Update" property in fields 1 & 2. field3 = field1 + field2 The above code would go...
5
by: Albert Wammes | last post by:
Is it possible to create form containing an editable crosstab querie? The only way I can think of is to create a temporary table where the results of the crosstab querie are stored, then presented...
18
by: cov | last post by:
I have a query where I'm attempting to pull data from 3 different tables using php and mysql. I had hoped to have a unique identifier to help ensure referential integrity but it appears that...
3
by: GazK | last post by:
I am hoping someone can steer me towards an elegant solution to a simple problem. I have a query result which returns an array of details about a physical building, including its address. The...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.