B
Bonnie
Hi there all! Using A02 on XP. I have some data (including
social security numbers) that is imported from a comma
delimited file (.csv). Once in a while there is a leading
zero that gets dropped in the .csv file and so once it
lands in access, a few SSN's have only 8 (or even 7)
digits.
What is the most efficient (but not too difficult) method
to run a query or somehow check to see if any SSN's need
to be edited? (I would love to then just insert the 1 or 2
leading zeros that have disappeared.) I can parse out all
9 digits and then put 'is null' in the criteria line of a
query to see if one is missing but it's got to able to be
done easier than that.
Thanks in advance for any help or advice on this!!! Luv U
guys!!!
social security numbers) that is imported from a comma
delimited file (.csv). Once in a while there is a leading
zero that gets dropped in the .csv file and so once it
lands in access, a few SSN's have only 8 (or even 7)
digits.
What is the most efficient (but not too difficult) method
to run a query or somehow check to see if any SSN's need
to be edited? (I would love to then just insert the 1 or 2
leading zeros that have disappeared.) I can parse out all
9 digits and then put 'is null' in the criteria line of a
query to see if one is missing but it's got to able to be
done easier than that.
Thanks in advance for any help or advice on this!!! Luv U
guys!!!