Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenate Values 1

Status
Not open for further replies.

dulla

Technical User
Feb 3, 2003
54
0
0
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

 
Rather than use the + which adds the values use & to join them together.

dyarwood
 
Try &

"hello" & "world" = "helloworld"

Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top