Hi I've got a table with around 600 bar codes in column [Barcode] formatted using "Code 128" font corresponding to a part number in column [Part Number].
I'd like to be able to print them all with the part number under the barcode and so need to find a way to concatenate with a line return / char(10), while keeping the font, in a new column in the table.
Could this be done using a user defined function =keepformat([@[Barcode]]) & CHAR(10) & keepformat([@[Part Number]])?
Any help greatly appreciated.
I'd like to be able to print them all with the part number under the barcode and so need to find a way to concatenate with a line return / char(10), while keeping the font, in a new column in the table.
Could this be done using a user defined function =keepformat([@[Barcode]]) & CHAR(10) & keepformat([@[Part Number]])?
Any help greatly appreciated.