Recent content by Reckoner

Thanks all for the help, got it working perfectly!

Thanks Frothingslosh, it's worked a treat. One more thing what if I wanted to do this for multiple columns into the same Table?

I know I can run a Append Query to pull the Genre column into the Genre Table I have created but I can't work out how to split say "Action, Adventure, Drama" to 3 rows keeping all the values in 1 column. I'm pretty sure I need some VBA to do this but haven't an idea where to start, any ideas...

All the Data is held within the Database, no files have been imported and new records are updated directly in the table. As such there is no text file. Also as new Records are added new Genre's could appear so I'm looking for a Query / some Code which could be set to run on opening a Form so...

I have a Table (Films) where I have a string of data separated by commas (Genre): (Ignore the Dashes that indicates break between Columns) Film - Year - Rating - Genre Catch Me If You Can - 2002 - 9 - Biographical, Crime, Drama Batman Begins - 2005 - 9 - Comic Book, Action, Adventure Heat -...