Jon K

Jon,
Your Conc() command is nearly exactly what I'm looking for, except in your example, the ID that you Group By is numeric, and in my situation, I must group on a text field. Can the script be modified so that it will work with my text column?

Hi Jon K,

your Concatenate Multiple Rows Access 2000 code is an excellent piece of code that has saved me a lot of times.

But i want to ask for something more complicated if you can help me .

I need a small adjustment of that piece of code but i am confused.

I want the concatenated field to include only distinct values

for example,when i concatenate multiple rows and the result is something like this: 1,1,2,1,3,3,4,1,3,2

i would prefer the rusult be 1,2,3,4

I tried to change the piece of code that refers to:

Do While Not rs.EOF
If Not IsNull(rs!Fld) Then

vFld = vFld & ", " & rs!Fld

End If
rs.MoveNext
Loop

but i dont know a lot of Functions and i got confused and couldnt make it work!

I think it will be a piece of cake for you
Can you help me??

Thank you in advance!!

Jon,

I'm using your Concatenate Multiple Rows Access 2000 code. How can I alphabetize the concatenated output? I need to do so for a project and the current code will not alphabetize.

Hi could you help at all with using your code but for txt files and not dbf?

http://www.access-programmers.co.uk/forums/showthread.php?p=957112#post957112

How can i display only those fields that the user has checked on the form, you will need to use VBA to build the query on the fly. See the below tread which you posted.

Thank you for your help.

http://www.access-programmers.co.uk/forums/showthread.php?t=142906

Jon,
(sorry to put this here, tried finding how to PM you but the option wasn't there). I'm trying to follow your tip on how to use sumproduct through the references library (http://www.access-programmers.co.uk/forums/showthread.php?t=68530)
but i'm having some difficulties. Could you give me a hand?

I've opened up the macro vba editor, i've then gone to Tools and found Microsoft Excel 11.0 Object Library but honestly, i don't know what to do next... :(