Query Help (Is it possible)

[Brian]

I have 3 tables defined as

Table_1
-table_1_id

Table_2
-table_2_id
-table_1_id
-table_3_id

Table_3
-table_3_id
-table_3_string

I have a query that has the following result

table_1_id table_3_string
------------------------------------------------
0 "string 1"
0 "string 2"
1 "string 3"
1 "string 4"
1 "string 5"
2
3
4

Basically i would like to make a query that would result

table_1_id table_3_string
------------------------------------------------
0 "string 1","string 2"
1 "string 3","string 4","string 5"
2
3
4

i would like to eliminate the duplicate entries and have all of
the strings stored in the same field... i don't know if this is
even possible to do

Thanks
Brian

 

[John Vinson]

Basically i would like to make a query that would result

table_1_id table_3_string

You need a little VBA code to do this. For sample code see:

http://www.mvps.org/access/modules/mdl0004.htm

 

[Brian]

I found that code and made a module out of it but
when i try to use it in my query, after replacing the table names
with my own table and field names i get the error undefined function
fConcatChile in expression

i don't understand this since i used the expresion builder to put the
function
in my query

thanks
brian

 

[Brian]

got it working
brian

I found that code and made a module out of it but
when i try to use it in my query, after replacing the table names
with my own table and field names i get the error undefined function
fConcatChile in expression

i don't understand this since i used the expresion builder to put the
function
in my query

thanks
brian

 

[Brian]

Unfortunately i need to do this dynamically and call the select statement
through ODBC in C++ code
so that rules out making a predefined query in access and calling it from my
program

does anyone have another way to accomlish the same results
thanks
Brian