custom aggregate function
Posted on 2001-07-06
I am trying to do the following:
in a select query I want to use Group by,and for one of the fields I want to be able to do a custom aggregate function (or call a function in a module) that concatenate the values of that field.
F1 F2 F3
A v1 a
B v2 b
B v2 c
I want the result of the query using group by and the custom function to be (group by F1,F2):
F1 F2 F3(after applying the function)
A V1 a
B V2 b,c ...... concatenate fields
in brief, I am trying to use a similar function to the Access aggregate functions (like sum) where I can use it with group by. Any help of outlining the code to do this and what values to pass to the function is appreciated.