By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

Linking multiple fields

P: n/a
This is probably a really easy thing but I'm being stupid today. I need to
be able to incorporate 5 fields;

Field1 = Number
Field2 = Number
Field3 = Text
Field4 = Text
Field5 = Date/Time

into one barcode field. I want to embed the fields into a barcode and have
it to be able to be scanned and pull that info out and place it into the
respective fields in the database.

Any help would be greatly appreciated.

Scott :o)
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Scott" <sm****@ii.net> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
This is probably a really easy thing but I'm being stupid today. I need to
be able to incorporate 5 fields;

Field1 = Number
Field2 = Number
Field3 = Text
Field4 = Text
Field5 = Date/Time

into one barcode field. I want to embed the fields into a barcode and have
it to be able to be scanned and pull that info out and place it into the
respective fields in the database.

Any help would be greatly appreciated.

Scott :o)


make friends with INSTR(), LEFT(),MID(),RIGHT() functions. If the
barcodes are always consistent, or has internal delimiters, like a
comma, this is easy. Otherwise, it can be a real pain.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.