split memo field content into rows in Query

[wvguy]

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

[NoellaG]

Hi,

if you need to show the names in separate rows, the "clean" approach would be to consider changing your database structure and create a new table with a one to many relationship to store the names.
then you could write a subroutine to separate the names in the memofield by the "," sign, and pump them in the new table.

grNG

[wvguy]

Thanks for your reply, I agree with you but I'm not able to do that. Thats why I'm looking for a way to do it in a query.