I have a query where I'm grabbing the first 14 characters of a field and concatenating that with "*". The problem is, some of the fields I'm pulling don't have 14 characters, so I end up with something that looks like "abcde *". Is there a simpler way to do what I'm trying to do or is there a way for me to suppress the blank spaces within my results? I've tried Trim to no success. Here is what my expression looks like:
Expr1: Left([EFT Payors]![Payer],14) & "*"
based off of the example above, I would like the result to be "ABCDE*" instead. Any ideas?