I have an access query, and I want to modify a text field as follows:
The query should add a certain number of spaces to the beginning of the field. How many? It'll calculate that, based on the length of another field.
Is this possible?
Note: the reason for this funny request is that it's for a report, where I will show two fields, and I want them to line up one after the other, but the first will vary in size.