Barcodes and access

[JamesCrawford]

Hi,

I am currently playing with access, and intergrating barcodes into it. I am able scan barcodes into a table, no problem, but now I want to take things a step further.

What I would like to be able to do is split a single barcode into seperate table columns using a delimiter

e.g. a barcode showing 12345/333/6789 (in barcode font)

would display 12345 333 6789 in seperate columns.

Does anyone have any ideas how I could achieve this, any guidance or assistance would be appreciated.

Cheers

James ;0)

 

[chrissie1]

i would use a querie for this and do something like this

select barcode, left(barcode,5) as firstcode, mid(barcode,7,3) as secondcode, right(barcode,4) as thirdcode frm barcodetable

that is if the numbers always have the same length "What a wonderfull world" - Louis armstrong

 

[JamesCrawford]

Thanks Chrissie1, Works great. ;-)