I'm Using Acces 2007
Here is what I'm looking to do.
The database has a memo field that has the following text
John Doe, jane doe, bob smith
when I make and run the query I would like it to seperate each name into its own row in the same column
John Doe
Jane doe
bob smith
Not all 3 names stacked in the same row
table name: member
field name: guests
Thanks for any help you can give me