Combining fields in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 09 Nov 2004 12:11 GMT

This is probably something really easy, Well I hope anyhow.

I have three fields used for barcoding, in one table F1, F2 and F3. I want
the three fields to be able to be combined to complete an EAN13 barcode.
(F1=2 digits, F2 and F3 = 5 digits each. Totaling 12 digits. EAN13 assigns
the 13th digit)

From there, I need to then be able to scan that barcode into a single field
and have the first two digits be sent to F1 and the next 5 to F2 and the
next 5 to F3.

Does this make sense and is there an easy way to set something up. Any help
greatly appreciated.

Reply to this Message

Bas Cost Budde - 09 Nov 2004 12:57 GMT

> This is probably something really easy, Well I hope anyhow.

Once you know!

> I have three fields used for barcoding, in one table F1, F2 and F3. I want
> the three fields to be able to be combined to complete an EAN13 barcode.
> (F1=2 digits, F2 and F3 = 5 digits each. Totaling 12 digits. EAN13 assigns
> the 13th digit)

Why is it three fields, in the first place? The barcode seems to me a
"unit" piece of information.

If you need to group or sort on the first two digits, you can easily do
this in a query by using the expression Left(EAN,2). Same for the next
five digits: Mid(EAN,3,5)

But well. To compose the EAN from F1, F2, F3, use this expression: F1 &
F2 & F3. I assume the fields are Text type (they need not be numerical,
I think)

> From there, I need to then be able to scan that barcode into a single field
> and have the first two digits be sent to F1 and the next 5 to F2 and the
> next 5 to F3.

You can devise some calculations that bring the parts into the fields
(using update queries and my expressions from above) but you will lose
this step altogether as you use just one field for the EAN.

Does that make sense?

Reply to this Message