G
Guest
I have a long integer field residentID with values ranging from 1-2800. I
want to use this field to create dummy SSNs with the same value but left
padded with zeros to nine spaces. If Visual FoxPro, I would do
update residents
set SSN = padl(alltrim(str(residentID)),9,'0') ;
How do I do it in MS Access?
Also, is there any document that gives details about every MS Access
function I can use to create expressions in queries?
Thanks!
want to use this field to create dummy SSNs with the same value but left
padded with zeros to nine spaces. If Visual FoxPro, I would do
update residents
set SSN = padl(alltrim(str(residentID)),9,'0') ;
How do I do it in MS Access?
Also, is there any document that gives details about every MS Access
function I can use to create expressions in queries?
Thanks!