help related to mid function

[ub1234567]

Hi,

i have a ssn number as parameter in reports.
ex. 203671234 that user prompts.

i need to display ssn number in formate 203-67-1234.
in report.

i used left and right function but i am confused regarding middle number ?

any help appriciated

 

[dboehne]

ssn = substr(ssn,1,3) || '-' || substr(ssn,4,2) || '-' || substr(ssn,6,9)

 

[ub1234567]

group 1

emp1 cd
emp1 ef
emp1 gh

i want to concatanet (cd ef gh) and display into group footer

for each group of emp i want to do this.
so i am geting in detail section that is,

emp1 cd
emp1 cd ef
emp1 cd ef gh

so i want to display whole string cd ef gh in group footer.

i made formula and i am puting that formula in group footer.
but it repeated last record means
it gives me
cd ef gh gh in group footer.

for each group i m reset my string in group header.

still it given me this problem

pls any one give me suggestion.

thanks

 

[milton747]

Dim ssn As String
Dim s As String
ssn = "123456789"

s = Mid$(ssn,1,3) + "-"
s = s + Mid$(ssn,4,2) + "-"
s = s + Mid$(ssn,6,4)

showFactoryStatus(s)

 

[DogCityGal]

try:

Format$( ssn, "000-00-0000" )

where ssn is the variable containing the social security number