Importing a table with SSN #s

[Payal Patel]

Hi,
i am running a query that matches two tables by social security numbers. The import file I am bringing in, some of the socials should have a zero in front but they don't. For example, the file is bringing it in as 12345678 instead of 012345678. Because of that, some of socials are not matching between the two tables. Does anyone know a way I can fix this?
Thanks in advance
P.

 

[pbaldy]

You can use the Format function to add the zero:

Format(FieldName, "000000000")

 

[SimonB1978]

Hi,

In your match criteria you could use Format(SSN_Field, "000000000"). It will add leading zero's as required.

Simon B.

 

[Payal Patel]

Thank you very much for this. It worked