Hi,
I am using the query form to create an append query. I do not have any problem to setup this.
My problem is to append to the other table just part of the text from a specific column.
For example on one table the column product has 'productsart1' and I would like to only append the 'part1' after the ''products:'. Since 'products:' is present before any text I am looking for, I can just select all the text after ':'.
I just cannot figure a way to do this in the query form.
Any help would be appreciated.
thanks.
I am using the query form to create an append query. I do not have any problem to setup this.
My problem is to append to the other table just part of the text from a specific column.
For example on one table the column product has 'productsart1' and I would like to only append the 'part1' after the ''products:'. Since 'products:' is present before any text I am looking for, I can just select all the text after ':'.
I just cannot figure a way to do this in the query form.
Any help would be appreciated.
thanks.