I have the following expression in a query from which my report gets its data.
The intention is for the concatenated field to appear on the report as follows:
Smith AB
Jones PJ
Nicholson BR
The initials are meant to align directly below one another, but the expression gives me:
Smith AB
Jones PJ
Nicholson BR
This I have to assume this is due to the variable length of the surnames, and to which spaces are added before we get to the initials part. I need the surname to fit into 30 char max and then the initials should be aligned below one another.
What have I got wrong here or is there a better way to do it?
Thanks in advance.
Code:
Left([points].[member] & Space(30),30) & [initials]
The intention is for the concatenated field to appear on the report as follows:
Smith AB
Jones PJ
Nicholson BR
The initials are meant to align directly below one another, but the expression gives me:
Smith AB
Jones PJ
Nicholson BR
This I have to assume this is due to the variable length of the surnames, and to which spaces are added before we get to the initials part. I need the surname to fit into 30 char max and then the initials should be aligned below one another.
What have I got wrong here or is there a better way to do it?
Thanks in advance.