I need a way to right justify fields in Access, so when I export the data to a flat text file it is space properly to be imported into a different system.
I have to import a file from an AS/400 into an Access database. In the database I must format some of the fields so that if the length of the data is not using the full length of the field leading 0's must be added. How can I automate this since their can be thousands of records. I then export...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.