I'm creating a simple Select query as a source for a Report and in the query I am concatenating several fields like so:
The problem is that the data in each field is space filled in order to use all characters. Is there a way to remove the spaces when concatenating so the results don't look like:
Code:
(PRESBR_LAST_NME & ", " & PRESBR_FRST_NME & " " & PRESBR_MDL_NME & " " & PRESBR_SUFX) AS FullName
The problem is that the data in each field is space filled in order to use all characters. Is there a way to remove the spaces when concatenating so the results don't look like:
Code:
Smith , John A Jr.