Field adding

[ncopeland]

Hi

I have a product code that is stored in a field.

I want to create another field that is a barcode for the product.

I need to put a star at the front and at the rear of the product code ie *123456*. I can't seem to be able to add this character to the fron or end of the new field.

Any ideas would be greatly appreciated.


Kind Regards

Neil.

 

[matty1404]

I am not sure I follow. Be more specific.

 

[ncopeland]

Got it sorted = "*" &[Product Code] & "*".

Thanks anyway.

Kind Regards


Neil.

 

[matty1404]

Yep, no problem