Concatenate Many values in one field

bogglebeats

Registered User.
Local time
Today, 14:20
Joined
Dec 19, 2002
Messages
53
Hello. I am trying to assign many values to one of my fields, TicketScan. Some values will be from a main form (Roll) and some on the subform (Bundle)that the TicketScan field is in itself. These are the values i would like to concatenate:
Form_Roll Objects:

RollID
TotalUnits
MarkerType

Form_Bundle Objects:

Pieces
Bundle (value = Q)
Operation (value = Q1)

so i would like something like:

Form_Bundle.TicketScan.Value = RollID + TotalUnits + MarkerType + Form_Bundle.Bundle.Value + Form_Bundle.Pieces.Value + Form_Bundle.Operation.Value

the plus sign here indicates the concatenation between the values with no spaces. Does anyone know the proper syntax? Thanks.

ameen
 
the ampersand ( & ) is used to concatenate

1 & 2 would be 12

1 &"-"& 2would be 1-2

follow?
 

Users who are viewing this thread

Back
Top Bottom