Input Mask

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I have established to calculated labels in two different
tables by concatenating 3-4 different fields on both
tables.
I want to join the labels on my tables since they are
unique to both tables but before the join I want to put
dashes in the numbers like so:


1-R01-AI049417-01A2-5751

How can I accomplish this???
 
Use concatenation:

=[field1]&"-"&[field2]&"-"&[field3]...
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Back
Top