Grouping Text Fields

I have a few tables in MS Access. The first table is a users table with an USERID field and other fields for the user. The second is a Groups table which has a USERID as a Foreign Key and a Name field.

I need to group the Name field of the Groups table based on the USERID field and make it into one record with all of the fields joined by semicolons ";".

Example:
GROUPS TABLE
USERID :: NAME
10 :: WINDOWS
10 :: LINUX
14 :: MAC OS X
14 :: LINUX
14 :: SOLARIS

This is the desired final result
10 :: WINDOWS; LINUX
14 :: MAC OS X; LINUX; SOLARIS

Is this an ongoing request (for a report) or is this a one time need?

The reason I ask this is becuase you are going to have to do this in VB code, there is no querying ability that allows this. If this is for a report, you will have to create a temp table and populate it with data everytime you create the report and delete the temp table after you are done with the report.

S-