Append some text to another table

[LKB6]

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.

 

[PHV]

yourAlias: Mid([product],10)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LKB6]

I understand what you do, but actually I have to check on the ':' that is allways present because 'product' can be product or something else.

So I will need to calculate first where is the ':' with an Instr of some sort, and take all the text after the ':' when I find where it is.

If I can do this in VBA, I just cannot find a way to do this in the field box that shows on the query form.

 

[Golom]

Just extend PHV's example

yourAlias: Mid([Product], Instr([Product],":")+1)

 

[LKB6]

Thanks.
Obviously when it is easy, I try to make it difficult.