Concatenate Rows within a Table (Microsoft Access)

[RakasArmas]

I have seen several threads on this topic, but none of the solutions has worked for me. I am not a VB guy, but have done extensive work in Access with queries, etc.

Here's the specific need:

Table1
Field:StudentID Field:Guardian
1 11222 Jessica
2 11222 Jose
3 11234 Rita
4 11234 John
5 11234 Grandma


I need to be able to show ALL guardians for a particular StudentID within a SINGLE record for export to another program.

Thanks in advance.
Kent

 

[PHV]

Have a look here: faq701-4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RakasArmas]

Table1
Field:StudentID Field:Guardian
1 11222 Jessica
2 11222 Jose
3 11234 Rita
4 11234 John
5 11234 Grandma


I need to be able to show ALL guardians for a particular StudentID within a SINGLE record for export to another program.

1 11222 Jessica, Jose
2 11234 Rita, John, Grandma

I'm not getting the VB code to work. Is there something simpler that would do the same thing? Or a more in-depth explanation for a beginning VB user?

Thanks again.

 

[PHV]

I'm not getting the VB code to work
Which code ? i.e. what have you tried ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886