Query Help (Is it possible)

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
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
 
got it working
brian

Brian said:
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
Click to expand...
 
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
 
Back
Top