Hi everyone, i have a general question about how to get a master list of records. For example, my recordset contains some info as follows:

Name: Applications:
John Smith Visual Foxpro
John Smith Microsoft Office
John Smith Photoshop

I would like use a select statment to return the following info:

John Smith, Visual Foxpro, Microsoft Office, Photoshop

into one record.

Can anyone help me?

Thanx