B
Bonnie
Hello! Using A02 in XP. Have a query that finds all SSN's
missing leading zeros. ShortSSN:=Len([SSN]) with <9 in
the criteria line. Would like to 'fix' them without the
user having to key in the missing zeros. I remember
seeing somewhere how to 'fill in' the leading zeros using
format requirements but couldn't locate it anywhere. Can
someone help?
Thanks in advance for any help or advice!
missing leading zeros. ShortSSN:=Len([SSN]) with <9 in
the criteria line. Would like to 'fix' them without the
user having to key in the missing zeros. I remember
seeing somewhere how to 'fill in' the leading zeros using
format requirements but couldn't locate it anywhere. Can
someone help?
Thanks in advance for any help or advice!