Formatting a Concatenated Field

[CoachBarker]

I have a query in my Access DB that I am using as a field in a vb.net program. Is there a way I can format the field in the query so all spacing is equal?
example:
I would like;
RN - W.Barker 1.0
RN - S.Barker 1.0
RN - J.Smith .8
NM - M.Moorehouse 1.0

instead of;
RN - W.Barker 1.0
RN - S.Barker 1.0
RN - J.Smith .8
NM - M.Moorehouse 1.0

in other words the last column should end up lined up based on the longest name.

SELECT tblEmployee.EmployeeID, tblEmployee.EmpFullName, tblEmployee.EmpStatus, tblEmployee.EmpPosition, [EmpPosition] & "-" & [EmpFullName] & "  " & [EmpStatus] AS ConName
FROM tblEmployee;

After the field is used in the vb.net program, it and other fields will be exported to a MS excel file for printing.

[weekend00]

I didn't see any difference from your two set of results.

maybe you tried to put spaces in the front to make them line up on the right side?
if so, you need to know the length of the longest one, suppose it is 50, then

select right(string(50," ") & [EmpPosition] & "-" & [EmpFullName] & " " & [EmpStatus], 50) AS ConName from ...

[CoachBarker]

thanks, I didn't notice that the forum formatting took the extra space out of the first set example. Will try what you posted. Thanks again.