I have an access database and need to split my memo fields (Source Data.png) into separate lines as per the results in (Output.png)
I have attached pictures to visually show what I am trying to do, its easier that a lot of confusing word's
I have also attached the sample access database which has the source data table to be converted (tblCatalogueDesc) and a form for the button to go on to run the required code/process to convert the data.
The tblLongText Load File is just a sample output as a guide in the database.
I am sorry that I am not good in the programming side and don't know how to add it to a command button. I have used Access for over 25 years but never had to do any heavy programming etc, so treat me like a newb
Any help will be appreciated, thank you
Cheers, Greg
I have attached pictures to visually show what I am trying to do, its easier that a lot of confusing word's
I have also attached the sample access database which has the source data table to be converted (tblCatalogueDesc) and a form for the button to go on to run the required code/process to convert the data.
The tblLongText Load File is just a sample output as a guide in the database.
I am sorry that I am not good in the programming side and don't know how to add it to a command button. I have used Access for over 25 years but never had to do any heavy programming etc, so treat me like a newb

Any help will be appreciated, thank you
Cheers, Greg